how to get null values in chart

Mon, 22 Feb 2016 05:22:48 GMT

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 :

Time Dimension :

Date	year	month	Year
1/5/2014	2014	1	1
1/6/2014	2014	1	1
1/7/2014	2014	1	1
1/8/2014	2014	1	1
1/9/2014	2014	1	1
1/10/2014	2014	1	1
1/11/2014	2014	1	1
1/12/2014	2014	1	2
1/13/2014	2014	1	2
1/14/2014	2014	1	2
1/15/2014	2014	1	2
1/16/2014	2014	1	2
1/17/2014	2014	1	2
1/18/2014	2014	1	2
1/19/2014	2014	1	3
1/20/2014	2014	1	3
1/21/2014	2014	1	3
1/22/2014	2014	1	3
1/23/2014	2014	1	3
1/24/2014	2014	1	3
1/25/2014	2014	1	3
1/26/2014	2014	1	4
1/27/2014	2014	1	4
1/28/2014	2014	1	4
1/29/2014	2014	1	4
1/30/2014	2014	1	4
1/31/2014	2014	1	4
2/1/2014	2014	2	4
2/2/2014	2014	2	5
2/3/2014	2014	2	5
2/4/2014	2014	2	5
2/5/2014	2014	2	5
2/6/2014	2014	2	5
2/7/2014	2014	2	5
2/8/2014	2014	2	5
2/9/2014	2014	2	6
2/10/2014	2014	2	6
2/11/2014	2014	2	6
2/12/2014	2014	2	6
2/13/2014	2014	2	6
2/14/2014	2014	2	6
2/15/2014	2014	2	6
2/16/2014	2014	2	7
2/17/2014	2014	2	7
2/18/2014	2014	2	7
2/19/2014	2014	2	7
2/20/2014	2014	2	7
2/21/2014	2014	2	7
2/22/2014	2014	2	7
2/23/2014	2014	2	8
2/24/2014	2014	2	8
2/25/2014	2014	2	8
2/26/2014	2014	2	8
2/27/2014	2014	2	8
2/28/2014	2014	2	8
3/1/2014	2014	3	8
3/2/2014	2014	3	9
3/3/2014	2014	3	9
3/4/2014	2014	3	9
3/5/2014	2014	3	9
3/6/2014	2014	3	9
3/7/2014	2014	3	9
3/8/2014	2014	3	9
3/9/2014	2014	3	10
3/10/2014	2014	3	10
3/11/2014	2014	3	10
3/12/2014	2014	3	10
3/13/2014	2014	3	10
3/14/2014	2014	3	10
3/15/2014	2014	3	10
3/16/2014	2014	3	11
3/17/2014	2014	3	11
3/18/2014	2014	3	11
3/19/2014	2014	3	11
3/20/2014	2014	3	11
3/21/2014	2014	3	11
3/22/2014	2014	3	11
3/23/2014	2014	3	12
3/24/2014	2014	3	12
3/25/2014	2014	3	12
3/26/2014	2014	3	12
3/27/2014	2014	3	12
3/28/2014	2014	3	12
3/29/2014	2014	3	12
3/30/2014	2014	3	13
3/31/2014	2014	3	13
4/1/2014	2014	4	13
4/2/2014	2014	4	13
4/3/2014	2014	4	13
4/4/2014	2014	4	13
4/5/2014	2014	4	13
4/6/2014	2014	4	14
4/7/2014	2014	4	14
4/8/2014	2014	4	14
4/9/2014	2014	4	14
4/10/2014	2014	4	14
4/11/2014	2014	4	14
4/12/2014	2014	4	14
4/13/2014	2014	4	15
4/14/2014	2014	4	15
4/15/2014	2014	4	15
4/16/2014	2014	4	15
4/17/2014	2014	4	15
4/18/2014	2014	4	15
4/19/2014	2014	4	15
4/20/2014	2014	4	16
4/21/2014	2014	4	16
4/22/2014	2014	4	16
4/23/2014	2014	4	16
4/24/2014	2014	4	16
4/25/2014	2014	4	16
4/26/2014	2014	4	16
4/27/2014	2014	4	17
4/28/2014	2014	4	17
4/29/2014	2014	4	17
4/30/2014	2014	4	17
5/1/2014	2014	5	17
5/2/2014	2014	5	17

Re: how to get null values in chart

sunny_talwar — Mon, 22 Feb 2016 10:09:21 GMT

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.

Re: how to get null values in chart

Mon, 22 Feb 2016 10:14:10 GMT

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

Re: how to get null values in chart

sunny_talwar — Mon, 22 Feb 2016 11:26:58 GMT

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

Re: how to get null values in chart

Tue, 23 Feb 2016 07:04:31 GMT

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 ???

topic Re: how to get null values in chart in App Development

how to get null values in chart

Re: how to get null values in chart

Re: how to get null values in chart

Re: how to get null values in chart

Re: how to get null values in chart