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: 
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.