topic Re: Show text only when dimension are selected in QlikView

Show text only when dimension are selected

Wed, 25 Nov 2020 16:16:04 GMT

I would like to format in the way that a text '>' is displayed only when the dimension has been selected.

Currently is has been hard coded as =[Business Unit P] & ' > ' & [Business Unit C1] & ' > ' & [Business Unit C2] at the title text; at which when CMG is not selected then it will show ENTERPRISE >>. I would like to achieve where CMG is not selected then it will be ENTERPRISE. Attached in the qlikview file.

Re: Show text only when dimension are selected

Anonymous — Tue, 18 Oct 2016 10:43:31 GMT

use this

if(GetFieldSelections([Business Unit P] ) = 'CMG', '>')

Re: Show text only when dimension are selected

shraddha_g — Tue, 18 Oct 2016 10:43:54 GMT

Try:

if(getselectedcount([Business Unit P] ) <> 0 ,

[Business Unit P] & ' > ' & [Business Unit C1] & ' > ' & [Business Unit C2] ,

[Business Unit P] & '>>'

)

Re: Show text only when dimension are selected

sunny_talwar — Tue, 18 Oct 2016 10:44:38 GMT

Try this:

=[Business Unit P] & If(Len(Trim([Business Unit C1])) > 0, ' > ' & [Business Unit C1]) & If(Len(Trim([Business Unit C2])) > 0, ' > ' & [Business Unit C2])

Re: Show text only when dimension are selected

Tue, 18 Oct 2016 12:13:34 GMT

Thanks Sunny and of course Greeshma and Shraddha!

Further to this question, is it possible to change the '>' to a image as I wish, i.e., an icon of folder like this:

EnterpriseCMGAGS_COMMOD

instead of Enterprise>CMG>AGS_COMMOD ?

Re: Show text only when dimension are selected

sunny_talwar — Tue, 18 Oct 2016 12:15:56 GMT

I don't think you would be a able to use image. A work around would be to place text box object to show up on conditional basis.