topic Re: For multiple field selections in QlikView

For multiple field selections

d_koti24 — Thu, 19 Nov 2015 13:46:42 GMT

Hi folks,

PFA..

I am able to select only one cat at a time ,for comparasion purpose i want to select muliple cat's at a time in same chart?

here i have a field CAT

i want select multiple options at a time how to achieve this

i.e: i want select 'A' ,"B' at time in same chart to get

Re: For multiple field selections

sunny_talwar — Thu, 19 Nov 2015 13:50:26 GMT

look at the attached:

Re: For multiple field selections

d_koti24 — Thu, 19 Nov 2015 14:35:35 GMT

Thanks Sunny..

Can you please explain me that exp?

=SubStringCount(Concat(DISTINCT CAT), 'A') = 1

Re: For multiple field selections

sunny_talwar — Thu, 19 Nov 2015 14:44:41 GMT

Concat(DISTINCT CAT) creates a concatenated list of CAT based on your selection. and then SubStringCount Counts all the Occurrences of A in it. If it equals 1, the expressions is showed, else not.