Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Nov. 30th, Webinar! Do More With Qlik Cloud Catalog & Lineage: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
lakshman5
Contributor III
Contributor III

How to get the Dimension values when there is no data for it in the Table(Zero values)

Hi Experts,

I want to display the year values regardless of having values for them in the excel sheet.

I have the formulae like this in the graph to calculate a measure:

Count({<A={'MissTime'},Season={'Preseason'},B={'Conditioning'}>}misstime_new)


In Graph, i have Year and this measure. Now when i apply filter on Team. The graph shows data only for 2015 data which is actually correct. But the business users want to see the data even for 2016 and 2017. Is there a way to achieve this in qlik sense?


Thanks,

Lakshman


3 Replies
kevinalvino
Partner - Creator
Partner - Creator

Hi lakshman5,

I don't know what is your Year field name, but for example sakes, lets name the field name of Year is "Year".

Your expression should be :

Count({<A={'MissTime'},Season={'Preseason'},B={'Conditioning'},Year>}misstime_new)


To put it simply, just Ignore the Year in the set analysis expression, it will show all the Year in the graph.


Best Regards,

Kevin

ChennaiahNallani
Creator III
Creator III

can you share same app

lakshman5
Contributor III
Contributor III
Author

Ok So, I got it using Count({<A={'MissTime'},Season={'Preseason'},B={'Conditioning'}>}misstime_new)+0*Count({1}misstime_new)