Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Manish
Creator
Creator

Scramble the dimension value in a bar when selected from a list box

Hi All

I want to hide the dimension's value in a bar chart when selected from "Peers" List box and show as it is when selected from "Clients"List box.

For example : If I select "Rob" in "Clients" listbox and "Pat" and "Glenn" in "Peers" list box then 

X-  Axis of a bar chart should have dimension values as Rob, Client PXXXX , Client GXXXX

See attached application.

I tried below cal. dimension but no luck. 

If(Wildmatch(GetFieldSelections(ClientName,';','','ScrambledClientName'),'*' & ClientName & '*'),
'Client ' & Left(ClientName,1) & 'XXXX',
ClientName
)

Please help.

1 Reply
Manish
Creator
Creator
Author

Hi ,

I got the result I am looking for.

=Aggr(Only(If(Wildmatch(GetFieldSelections(ClientName,',','','ScrambledClientName'),'*'&ClientName&'*'),
Dual(Left(ClientName,1) & 'XXXX',ClientName),
ClientName
)),ClientName
)

Still if you guys think there is better way to achieve it , please feel free to share.

Thanks