Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
maxime66
Creator
Creator

Set analysis

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

1 Solution

Accepted Solutions
sunny_talwar

Try this:

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

With blue light selected

Capture.PNG

With everything except blue selected

Capture.PNG

With nothing selected

Capture.PNG

View solution in original post

4 Replies
Anonymous
Not applicable

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

Try this:

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

With blue light selected

Capture.PNG

With everything except blue selected

Capture.PNG

With nothing selected

Capture.PNG

narayanamsn
Creator
Creator

Hi ,

You can try this expression in your table:

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

maxime66
Creator
Creator
Author

Hy Sunny T

so simple , so perfect !

Thank you.