Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Cyclic Groups in Qlik Sense

100% helpful (3/3)
cancel
Showing results for 
Search instead for 
Did you mean: 
Patric_Nordstrom
Employee
Employee

Cyclic Groups in Qlik Sense

Last Update:

Nov 20, 2020 3:40:05 AM

Updated By:

Patric_Nordstrom

Created date:

Nov 20, 2020 3:31:37 AM

Attachments

This doc and app shows a workaround how to make cyclic groups for dimensions and measures. Qlik Sense 2018 November or later is required. The workaround is based on a variable and the button. The solution is not self service but no extensions or add-ons are required and using master items simplifies the usage.

Cyclic Dimension Group

  1. Add a variable vDimension and set it to Year.
  2. Add a button, set the label to =vDimension and add an set variable action for vDimension to toggle the dimensions:
    =pick(match(vDimension,'Year','Quarter','Month'),'Quarter','Month','Year')

Write dimension dependent expressions using vDimension (instead of GetCurrentField), ex:
=Sum(Sales)/ Sum(Total Aggr(Sum(Sales), $(=vDimension)))

For convenience, add master dimension CyclicDimension =$(vDimension) set to label =vDimension and make the button a master visualization.

Cyclic Measure Group 

  1. Add a variable vButton and set it to Sales
  2. Add a button set the label to vButton and add a set variable action for vButton to toggle the measures:
    =pick(match(vButton,'Sales','Orders','COS'),'Orders','COS','Sales')
  3. Add a variable vMeasure and set it to hold the measure expressions:
    =pick(match(vButton,'Sales','Orders','COS'),'sum(Sales)','count(OrderID)','sum(COS)')

For convenience, add master measure CyclicMeasure =$(vMeasure) set to label =vMeasure and make the button a master visualization.

 

allcyclic.gif

 

This technique has been mentioned before in: 
Top-10-Viz-tricks-Qonnections-2019
Top-10-Viz-tricks-Part-2

There are several proposals for cyclic groups, thanks for the inspiration:

Juraj Misina, https://dataqlues.com/getobjectfield-function-and-alternate-dimensions/

 

 

Labels (2)
Comments
RoryMcHugh-Catalyst
Partner - Contributor II
Partner - Contributor II

Thanks for posting this workaround, really useful 😄

It would be great if this could be a feature that's just built in, rather than a workaround. Do you know if it's on the list to be added?

 

cotiso_hanganu
Partner - Creator III
Partner - Creator III

We are using for 10 years an equivalent approach, improved  even more after we discovered the Instant App from Steve Dark: https://www.quickintelligence.co.uk/instant-qlik-sense-application/

PS:Agree with Rory... (despite all the love I have for Patric) 
It should have been already built in !
(It was in Qlikview, 20 years ago...)

PPS: At least we will be able soon to edit fonts and font colors without fighting with css... 

Version history
Last update:
‎2020-11-20 03:40 AM
Updated by: