Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lakshman5
New 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


Tags (1)
3 Replies
kevinalvino
Contributor

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

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
Contributor III

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

can you share same app

lakshman5
New Contributor III

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

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