Empty values as 0

Thu, 17 Jul 2014 18:50:37 GMT

Hello,

My data table looks like this:

store	date	month	sales
a	1/1/2014	1	100
a	1/2/2014	1	150
a	2/1/2014	2	200
b	2/1/2014	2	300

And I have a “month” list box:

month

I need to create a straight table in which all stores appear, regardless of the month chosen. If there is no value for the store in the data table for the chosen month, I need to have the number 0 in the table. For example, if the user chooses month 1 from the list box, the straight table should look like this:

store	sales
a	250
b	0

Any idea?

Thanks

Re: Empty values as 0

gmoraleswit — Thu, 17 Jul 2014 19:58:22 GMT

Do not check the following option:

Chart properties -> Presentation -> suppress zero values

Re: Empty values as 0

MK_QSL — Thu, 17 Jul 2014 20:05:57 GMT

Please check enclosed file...

topic Re: Empty values as 0 in QlikView

Empty values as 0

Re: Empty values as 0

Re: Empty values as 0