topic Re: Set analysis in QlikView

Set analysis

maxime66 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Qlikers,

I would like to count only blue cars in my graphic.

if no filter i want 2 lines

if i filter everything but *blue* i want 0 line

and when i filter "blue light" i want 1 line (same for "blue strong")

i have a lot if different Blue in my database si i can't list them in my set analysis.

Thanx for your help !!

Re: Set analysis

Anonymous — Wed, 22 Jun 2016 00:08:46 GMT

Hi maxime66,

Why don't you try a calculated dimension instead. Please check the attached file, I have modified your current table to meet your requirement. Check the expression used in dimension tab and don't forget to check the "Supress when value is null" option.

I hope it helps.

Regards,

-- Karla

Re: Set analysis

sunny_talwar — Wed, 22 Jun 2016 00:26:19 GMT

Try this:

=Count({<cars_color*={'*blue*'}>} nb)

With blue light selected

With everything except blue selected

With nothing selected

Re: Set analysis

narayanamsn — Wed, 22 Jun 2016 03:41:08 GMT

Hi ,

You can try this expression in your table:

count({$*<cars_color={'*blue*'}>}nb). This will achieve the desired results..

Re: Set analysis

maxime66 — Wed, 22 Jun 2016 07:51:15 GMT

Hy Sunny T

so simple , so perfect !

Thank you.