02035736917

I am going to Share My knowledge, How to create a Cyclic Measure in Qliksense. We can Create a 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 the first Measure in the button and click on save.


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

Step 4:
Then go to the 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 the sheet and select a Created variable named vMeasure from the Drop down and select Show as Button, Style as Qlik.


Step 6:
Then go to the 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 button, the corresponding Measure related Trend will be visible in the Chart.