Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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