Show text only when dimension are selected

[#1]

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.

[Anonymous]

use this

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

[shraddha_g]

Try:

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

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

[Business Unit P]  & '>>'

)

[sunny_talwar · Accepted solution]

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

[#5]

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 ?

[sunny_talwar]

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.