topic Re: Chart Title Expression Update With Drill-Dimension and getselectedcount() in App Development

Chart Title Expression Update With Drill-Dimension and getselectedcount()

carlcimino — Wed, 23 Mar 2022 20:26:12 GMT

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 '))

Re: Chart Title Expression Update With Drill-Dimension and getselectedcount()

vinieme12 — Mon, 18 Apr 2022 09:09:24 GMT

unfortunately there is no equivalent for getcurrentfield() in qliksense

you can use variables instead and change your approach

https://community.qlik.com/t5/New-to-Qlik-Sense/Qlik-Sense-SaaS-Dimension-Variable-amp-If-Else/m-p/1869545#M196954

Re: Chart Title Expression Update With Drill-Dimension and getselectedcount()

carlcimino — Thu, 16 Jun 2022 16:39:30 GMT

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?