Qlikview Question-1

Is there any function which creates Synthetic key in Qlikview?
Yes/No. Please comment if there is any function

Synthetic key is due to more than one common key between tables in Script. We don't have synthetic keys until there are no two common keys between tables. 
But when we use interval match function, It will create synthetic key as this is the nature of this function. Using proper join, we can remove this 

Dynamic field change in Straight table - Qliksense

Below is the process to change the dimension dynamically in table in which all measures remains same.

Build a inline table with one field and give the field names as values for that field

Example inline table looks as below

Load * Inline
[
Dimension
Dimension1,
Dimension2,
Dimension3,
];


Use below expression in the dimension field for straight table

=IF(GetSelectedCount(Dimension)=1,
IF(Dimension='Dimension1',Dimension1,
IF(Dimension='Dimension2',Dimension2,
IF(Dimension='Dimension3',Dimension3,
))),Dimension1)

Use below expression in the straight table label to reflect label name dynamically whenever make a selection in the filter

=IF(GetSelectedCount(Dimension)=1,
IF(Dimension='Dimension1','Dimension1',
IF(Dimension='Dimension2','Dimension2',
IF(Dimension='Dimension3','Dimension3',
))),'Dimension1')

and also use the same above expression in the filter title to get title updated dynamically updated when selection is changed. Default section is 'Dimension1' in all the expressions



Below screen shot explains a filter where the dimension needs to be selected and will change automatically in the straight table

ODAG - On demand app generation in qliksense

–Enables users to generate Qlik Sense applications on-demand i.e. after interactively selecting the data they are interested in discovering insights on.

–Provides an ability to load and analyse data sources with large volumes of data in Qlik sense.
–Loading entire volume of data from a larger data source is inefficient 
–But to make representative analysis the entirety of the data should be accessible
On demand provides a solution for that provides users with a "shopping list" experience enables them to interactively populate their apps with a subset of data such as time period, customer segment, or geography.

                  ODAG – Configuration
On-demand app generation is controlled by the On-demand app service which is managed in the Qlik Management Console.
–The service is disabled by default and must be enabled before selection and template apps can be linked and on-demand apps generated.

                    ODAG – Components

–On Demand Selection App: Loads an aggregate view of the big data source with modest dimension granularity

–On Demand Template App: its load script contains data binding expressions used to formulate the queries made on the data sources.

–App Navigation links

–Navigation bar – Each sheet in a selection app contains an app navigation bar

–Navigation Point – Once a navigation link is dropped in an app’s sheet’s navigation bar it’s called a navigation point

 

New visualizations and features in Qliksense April 2018

                                             Waterfall Chart

Shows how the Initial Value is affected by Intermediate Positive and Negative Values

Whole Bars represents Initial and Final Values of Chart.

Floating/Hanging Bars represents Intermediate Positive and Negative Values

Example below shows how Initial Value Sales is impacted after Intermediate deductions of Expenses and Taxes are applied, and finally showing Net Income as Sub Total.

                    Distribution Plot Chart

To Show Range and Distribution of groups of numerical data

Data is plotted as Value points and Bounding box highlights the range of distribution.

Stretched box shows high distribution compared to Compressed box with low distribution.

Box color and point color can be changed accordingly.

Example below shows how Sales are distributed for each Sub Category (Represented as box stretch) and across each Quarter (Represented as Value points).

                         Histogram Chart

Shows distribution of numerical data over a continuous interval.

Data is organized into bins and height of bin represents frequency.

Grouping of data into bins can be customized by adjusting the Width of bars or Setting number of bars to display.

Below example shows temperature frequency of a Country in an year. (Bar Width set to 2 and so for every 2 degrees a bin is created).

                                Box Plot Chart

Provides Range and Distribution of Numeric Data

Components of Box Plot

Whiskers- Represents Reference value which is a Quartile, Percentile or Standard Dev based.

Box- Represents First and Third Quartile values with a Median Line.

Outliers- Represents data points falling outside the Whisker range.

Below example of box Plot Chart shows distribution of Sales by Month.

                    Maps visualizations 

Qlik Sense April 2018 features significant improvements to the built-in maps visualization

Support for multiple layers.

Labels for point layers and area layers

Quick look up of countries, divisions, cities,

     postal code areas

No fixed upper limit of number of objects,

     number of bubbles on area layer

Circle select with distance measure

Drill down support