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

[Anonymous]

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

[kevinalvino]

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]

can you share same app

[Anonymous]

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