Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello I have a drill dimension with >2 dimensions (image below). I'd like to get the chart title reflect the level of the drill group the user is in. Trying to utilize getselectedcount() unsuccessfully for levels below the 2nd dimension in the drill dimension. Any help would be appreciated.
I have this as the expression below in the Subtitle but can't seem to get it to work for any level below the 2nd one. I've tried all sorts of variations of the GetSelectedCount.
Level 1 = [Segment Group]
Level 2 = [IT Group]
Level 3 = [Tower]
Level 4 = [Sub Tower]
Level 5 = [Cost Center Name]
=if(GetSelectedCount([Segment Group])=0,'Segment Group ',
if(GetSelectedCount([Segment Group])=1,'IT Group '))
unfortunately there is no equivalent for getcurrentfield() in qliksense
you can use variables instead and change your approach
using variables to change the dimension is fine if you are equating the approach to a cyclic group. The requirement is a drill group just like users are used to with QV behavior. Wouldn't what you suggest introduce an unnecessary button click on the end users part to filter before selecting the next dimension to see. how would you do what you suggest with pick/match/variable and fulfill the drill group requirement without changing the end user behavior?