Let: Calculates the expression assigned to it and sets the expression result to the variable.
Set: Assigns the value(or expression which is after the equal sign) as it is without compute.
Example:
Set vVar=2+3; //vVar has the expression 2+3 as value we have to compute it using $(vVar) which returns 5
Let vVar=2+3;//vVar has the computed value 5
A reference line is a line intersecting the chart area from a given point on the measure axis. You can use a reference line to indicate a certain level of chart data. The reference line is only drawn if it falls within the current range of the measure axis. You can have several reference lines in the same chart. The reference line is only drawn if it falls within the current range of the axis from which it origins.
A ‘Reference Line’ can also be considered as ‘Trend Line’
Reference lines are available in bar charts, gauges, line charts, and scatter plots in Qliksense.
Example:
When we want to sort data based on expression, we can go with Sort by Expression available in
For Example the Quarter values may change according to measure, but the representation should be like Q1, Q2, Q3 and Q4. Below expression comes handy:
Match(Quarter,’Q1′,’Q2′,’Q3′,’Q4′)
Set Analysis which provides to apply filters to the charts in dimension or expression while displaying.
Example: Consider in the chart only 2017 data is to be shown irrespective of the selections made in the application. Set Analysis comes into picture at this point:
=Count({<Year ={2017}>}Distinct [Company Name])
In Qliksense, we have feasibility with the master items. There are situations where we need to place same set of filters in different sheets of the application, where the Master items will be pretty helpful. Creating the master item would enable changes applied to it reflect in all the other sheets without any manual intervention.
Master items consists of :
Qlikview 