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.

NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
Showing results for 
Search instead for 
Did you mean: 
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:


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?



3 Replies
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 :


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

Best Regards,


Creator III
Creator III

can you share same app

Contributor III
Contributor III

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