Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Jsobrinho77
Creator
Creator

Show missing values as 0 set analysis

Hi guys,

I have a measure, and I would like to show all values, if not have a value for some filters, show 0, but always show all values for dimension fieldB.

Dimension= fieldB

measure= count ({<flag={1}>} distinct fieldA &'|' & fiedlB)

Labels (3)
7 Replies
vincent_ardiet_
Specialist
Specialist

Try this: 
measure= count ({<flag={1},fiedlB>} distinct fieldA &'|' & fiedlB)

Jsobrinho77
Creator
Creator
Author

first of all, thank you for your answer, but not working.

Its shows only 1 line of fieldB if a filter for example FilterC

vincent_ardiet_
Specialist
Specialist

Yes sorry, I've done the opposite of you want, try this, this makes the expression insensible to whatever selections except for fieldB:

count ({1<flag={1},fieldB=p(fieldB)>} distinct fieldA &'|' & fieldB)

Jsobrinho77
Creator
Creator
Author

sorry, I will try explain better.

I want to select all filters, and all fields, and reflect this in the value.

For example:

FilterC = its country

I would like to filter the country, and the quantity ( count distinct  fieldB will change ) but I would like to keep showing all values to fieldB. If not have a country selected, show 0 instead of suppress the fieldB. So I can't ignore all selections

Gabbar
Specialist
Specialist

Try:
Measure = "Your Measure "  + 0*Count({1}Field_1)

Jsobrinho77
Creator
Creator
Author

I think its works, let me check

Gabbar
Specialist
Specialist

Try  using Include Zero Values From Add ons in table