02035736917

I am going to Share My knowledge, How to create Cyclic Measure in Qliksense. We can Create Cyclic Measure in Qliksense Using QsVariable Extension.

Cyclic Measure by using QsVariable Extension:

To see the New Visitors by Date, Year, Quarter and Month using QsVariable extension need to follow the below steps.

Step 1:
Download and install the QsVariable extension from Qlik Branch.
Desktop Users Copy and Paste the Extension under below folders:
  1. C:\Users\bsbi\Documents\Qlik\Examples\Extensions
  2. C:\Users\bsbi\Documents\Qlik\Sense\Extensions\Templates
Server Users Go to QMC > Extensions > Import QsVariable Zip Folder.

Step 2:
Create a Variable named vMeasure in the variable editor and assign the default Measure i.e., 1 as first Measure in the button and click on save.


Step 3:
Drag and Drop QS Variable extension named Variable into sheet and select Created variable named vMeasure from the Drop down and select Show as Button, Style as Qlik.

Step 4:
Then go to values section assign each Measure Label by clicking on Add Alternative and assign the Values as 1, 2, and 3.


Step 5:
Now Drag and drop chart into Sheet. Under Dimension add Month Field and Under Measure add below Expression

if('$(vMeasure)'=1,num(Sum([New Visitors]),'#,##0'),
if('$(vMeasure)'=2,num(Sum([Unique Visitors]),'#,##0'),
if('$(vMeasure)'=3,num(Sum([Bounce Rate]),'#,##0.0%')
)))


To change Measure Label dynamically as per Button Selections use the below expression

if('$(vMeasure)'=1,'New Visitors',
if('$(vMeasure)'=2,'Unique Visitors',
if('$(vMeasure)'=3,'Bounce Rate'
)))


Use Number Formatting as Measure Expression

Step 6:
Now for Dynamic Titles go to General > Click on Title > enter this expression>
='Monthly Wise' &'-'&if('$(vMeasure)'=1,'New Visitors',
if('$(vMeasure)'=2,'Unique Visitors',
if('$(vMeasure)'=3,'Bounce Rate'
)))

Now by clicking on each Buttons the corresponding Measure related Trend will be visible in the Chart.



Cyclic Dimension and Measure by using QsVariable Extension:
To see the New Visitors, Unique Visitors and Bounce Rate by Date, Quarter and Month using QsVariable extension need to follow the below steps.

Step 1:
Download and install the QsVariable extension from Qlik Branch.
Desktop Users Copy and Paste the Extension under below folders:
  1. C:\Users\bsbi\Documents\Qlik\Examples\Extensions
  2. C:\Users\bsbi\Documents\Qlik\Sense\Extensions\Templates
Server Users Go to QMC > Extensions > Import QsVariable Zip Folder.

Step 2:
Create Variables named vDimension1 and vMeasure in the variable editor and assign default Values as 1.

Step 3:
Drag and Drop QS Variable extension named Variable into sheet and select Created variable named vDimension1 from the Drop down and select Show as Button, Style as Qlik.

Step 4:
Then go to values section assign each Dimension Label by clicking on Add Alternative and assign the Values as 1, 2, and 3.



Step 5:
Same like above steps again Drag and Drop QS Variable extension named Variable into sheet and select Created variable named vMeasure from the Drop down and select Show as Button, Style as Qlik.


Step 6:
Then go to values section assign each Measure Label by clicking on Add Alternative and assign the Values as 1, 2, and 3.

Step 7:
Now Drag and drop chart into Sheet. Under Dimension add below Expression
=$(=Pick(Match($(vDimension1),1,2,3),'Date','Quarter','Month'))

For Dynamic Dimension Label add below expression
=Pick(Match($(vDimension1),1,2,3),'Date','Quarter','Month')

Under Measure add below Expression

=Pick(Match($(vMeasure),1,2,3),
Pick(Match($(vDimension1),1,2,3),
aggr(Sum([New Visitors]),Date)
,aggr(Sum([New Visitors]),Quarter)
,aggr(Sum([New Visitors]),Month)
)
,Pick(Match($(vDimension1),1,2,3),
aggr(Sum([Unique Visitors]),Date)
,aggr(Sum([Unique Visitors]),Quarter)
,aggr(Sum([Unique Visitors]),Month)
)
,Pick(Match($(vDimension1),1,2,3),
aggr(Sum([Bounce Rate]),Date)
,aggr(Sum([Bounce Rate]),Quarter)
,aggr(Sum([Bounce Rate]),Month)
)
)


To change Measure Label dynamically as per Button Selections use the below expression
=Pick(Match($(vMeasure),1,2,3),'New Visitors','Unique Visitors','Bounce Rate')


Step 8:
Now for Dynamic Titles go to General > Click on Title > enter this expression>

=if(vMeasure=1,
'New Visitors',
if(vMeasure=2,
'Unique Visitors',
if(vMeasure=3,
'Bounce Rate',
)))
& ' by ' &
if(vDimension=1,
'Date',
if(vDimension=2,
'Quarter',
if(vDimension=3,
'Month'
)))


Now by clicking on each Buttons the corresponding Measure related Trend will be visible in the Chart.