topic dates in dimension in QlikView

dates in dimension

kamielrajaram — Wed, 29 Feb 2012 08:46:16 GMT

Good day,

Please could you assist. I would like to display all dates for my month selection in a dimension irrespective if there is data or not.

Thank you in advance

Kamiel

dates in dimension

ToniKautto — Wed, 29 Feb 2012 08:50:00 GMT

Please provide a sample QVW with your chart so that all the dimensions and expressions can be evaluated.

dates in dimension

perumal_41 — Wed, 29 Feb 2012 08:59:06 GMT

Hi,

Uncheck Suppress Zero Value and Suppress Missing in Persentation Tab.

dates in dimension

CELAMBARASAN — Wed, 29 Feb 2012 09:14:49 GMT

Hi,

Check Show all values option in the dimension tab for that dimension.

Uncheck Suppress Zero Value and Suppress Missing in Persentation Tab.

Celambarasan

dates in dimension

kamielrajaram — Wed, 29 Feb 2012 09:18:54 GMT

Thnaks, I have done this , but an example :

The date range I have chosen is from 01/02/2012 to 29/02/2012. There is only data from the the 13/02/2012. Ideally I want to show all dates within the date range. that means that from the 1st to the 12th the column would be null, but still needs to tbe shown.

Kamiel

dates in dimension

CELAMBARASAN — Wed, 29 Feb 2012 09:24:02 GMT

Hi,

Do you have that range dates in your calendar table?

Celambarasan

dates in dimension

Wed, 29 Feb 2012 09:46:42 GMT

Hi,

I think you will have to create a caldendar table in your script and assign 0 values to the each date to get the all dates apprear in your data irrespective of actual data.

Sandip.

Re: dates in dimension

Wed, 29 Feb 2012 09:47:03 GMT

Hi,

I think you will have to create a caldendar table in your script and assign 0 values to the each date to get the all dates apprear in your data irrespective of actual data.

Sandip.