Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

how to get null values in chart

how to get null values for particular week/month dimension with different metrics

now I have two tables i.e. one is fact table and another one is time dimension

now If load these two table it will do a join based on date .... now I want to plot a chart with last 12 weeks

week will the dimension and I selected only top 12 weeks....  but when I use the measure number of created and use it the graph ..

I am getting the only top 12 weeks which have values...

Example : if I plot weeks between 1 to 12 .... it is showing 1 to 14 weeks where week3 and week 7 is missing since they don't have data..

but I want to show exactly 1 to 12 though I don't have data for those weeks... I want to show this as '0'

can any one help me with this?

fact  :

Capture.PNG

Time Dimension :

    

DateyearmonthYear
1/5/2014201411
1/6/2014201411
1/7/2014201411
1/8/2014201411
1/9/2014201411
1/10/2014201411
1/11/2014201411
1/12/2014201412
1/13/2014201412
1/14/2014201412
1/15/2014201412
1/16/2014201412
1/17/2014201412
1/18/2014201412
1/19/2014201413
1/20/2014201413
1/21/2014201413
1/22/2014201413
1/23/2014201413
1/24/2014201413
1/25/2014201413
1/26/2014201414
1/27/2014201414
1/28/2014201414
1/29/2014201414
1/30/2014201414
1/31/2014201414
2/1/2014201424
2/2/2014201425
2/3/2014201425
2/4/2014201425
2/5/2014201425
2/6/2014201425
2/7/2014201425
2/8/2014201425
2/9/2014201426
2/10/2014201426
2/11/2014201426
2/12/2014201426
2/13/2014201426
2/14/2014201426
2/15/2014201426
2/16/2014201427
2/17/2014201427
2/18/2014201427
2/19/2014201427
2/20/2014201427
2/21/2014201427
2/22/2014201427
2/23/2014201428
2/24/2014201428
2/25/2014201428
2/26/2014201428
2/27/2014201428
2/28/2014201428
3/1/2014201438
3/2/2014201439
3/3/2014201439
3/4/2014201439
3/5/2014201439
3/6/2014201439
3/7/2014201439
3/8/2014201439
3/9/20142014310
3/10/20142014310
3/11/20142014310
3/12/20142014310
3/13/20142014310
3/14/20142014310
3/15/20142014310
3/16/20142014311
3/17/20142014311
3/18/20142014311
3/19/20142014311
3/20/20142014311
3/21/20142014311
3/22/20142014311
3/23/20142014312
3/24/20142014312
3/25/20142014312
3/26/20142014312
3/27/20142014312
3/28/20142014312
3/29/20142014312
3/30/20142014313
3/31/20142014313
4/1/20142014413
4/2/20142014413
4/3/20142014413
4/4/20142014413
4/5/20142014413
4/6/20142014414
4/7/20142014414
4/8/20142014414
4/9/20142014414
4/10/20142014414
4/11/20142014414
4/12/20142014414
4/13/20142014415
4/14/20142014415
4/15/20142014415
4/16/20142014415
4/17/20142014415
4/18/20142014415
4/19/20142014415
4/20/20142014416
4/21/20142014416
4/22/20142014416
4/23/20142014416
4/24/20142014416
4/25/20142014416
4/26/20142014416
4/27/20142014417
4/28/20142014417
4/29/20142014417
4/30/20142014417
5/1/20142014517
5/2/20142014517
Tags (1)
4 Replies
MVP
MVP

Re: how to get null values in chart

Do you have master calendar in your application? If you do may be you just need to uncheck 'Suppress Zero Values' on the presentation tab. May be share a sample to show the problem you are facing.

Not applicable

Re: how to get null values in chart

Suppress Zero Values' option will be in qlikView but not in qlik sense.... can you let me know the equivalent in qlik sense... I have check the 'show zero values ' in data tab ... but that didn't worked.... there is no option check that in presentation -> x-axis tab....

is this a limitation in qlik sense??

because for few weeks I have zero data , The bar chart only shows the results that aren't 0..

if you see in the below chart ... june data is missing  since the value =0.. here I want to show all possible month names though the result is 0

Technically I don't have rows associated to month june in the fact table.

But I have Jun listed in my master calendar

Untitled.png

MVP
MVP

Re: how to get null values in chart

The above image seems to be from QlikView, which made me think you might have mistakenly selected Qlik Sense

Capture.PNG

Not applicable

Re: how to get null values in chart

yes the image is from QV ... that is just an example..... But I want the solution for Qlik Sense

Technically I don't have any rows associated to that month ....

Is this a limitation in Qlik sense ???