Dynamic column name in cyclic group in QlikSense

[Karim_Khan]

Hi Folks,

Again am here with regards to QlikSense not sure if its feasible,I am trying to pick up dynamic name of cyclic group dimensions based upon column selection.When i select Dim1 it should show name of column as Dim1 and if select Dim2 it should show name of column as Dim2 and select Dim3 it should show name of column as Dim3.

I know the workaround using Variable Input which will allow to pick up the value dynamically but i need this work directly with column selection of cyclic group.

Unfortunately cyclic group dimensions are not getting unlink.

Any example will be highly appreciated !!

[stevedark]

Hi @Karim_Khan 

Unfortunately this is another example of where there was a simple function to do this in QlikView, but that very basic functionality has not been ported across to Sense (or it hadn't last time I checked).

I tend to do cycle groups by having a data island with dimensions in and then have the current dimension selected from a filter pane. As well as allowing you to grab the name of the current value easily to put on a chart legend or title it also allows you to have the same dimension shown across many charts (just as QlikView used to do).

Sorry I can't be of more help on this.

Steve

[Karim_Khan]

Hi @stevedark,

I do agree upon this restriction,hence i am intend to try with drill down approach and its giving me expetced output now.

=if( GetSelectedCount(Dim1)>=1 AND GetSelectedCount(Dim2)>=1 and GetSelectedCount(Dim3)>=1, 'Dim3',

if( GetSelectedCount(Dim1)>=1 AND GetSelectedCount(Dim2)>=1, 'Dim2',

IF(GetSelectedCount(Dim1)>=1, 'Dim1',
'No Dim Selected')))

The only concern is i can't unlink drill down group to rename the lable dynamically.

Regards,

KK

[stevedark · Accepted solution]

Hi @Karim_Khan 

This appears to be a drill down group, rather than a cycle? The method is quite similar though.

What you will typically have is two expressions, like you have there, one which gives the dimension name and the other than gives the label. These are then applied to the relevant places.

Typically I would create these into variables, so they can be referred to from multiple places.

Take a look at this blog post, and the associated app, and you will see a number of examples of dynamic dimensions:

https://www.quickintelligence.co.uk/instant-qlik-sense-application/

Hope that helps.

Steve