Set analysis

[maxime66]

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 !!

[Anonymous]

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

[sunny_talwar · Accepted solution]

Try this:

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

With blue light selected

With everything except blue selected

With nothing selected

[narayanamsn]

Hi ,

You can try this expression in your table:

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

[maxime66]

Hy Sunny T

so simple , so perfect !

Thank you.