Missing values on time dimension

[0li5a3a]

Hi all,

I would like  someone to help me to display a calendar month if I don't have data. I read all the topics but I couldn't find  an answer.

Please find the attached files they contain some data.

I want to display all the month-year even I don't have data in that month.  I tried to add an extra expression and uncheck all the buttons to don't display the data but in the legend I still can see  the nulls .... This is annoying and I need to display the months where we don't have any data. As far as I understand QlikView can't handle this.  I want to thank you in advance.

Regards C

[sunny_talwar]

When data isn't available, QlikView cannot display it... check here:

Generating Missing Data In QlikView

[0li5a3a]

Hi Sunny,

Thanks you for your files but I still don't understand how to generate the missing values.

Regards,

C

[hari8088]

deselct Suppress zero values for  presentation tab .

[0li5a3a]

I done this but this doesn't works.......

[hari8088]

It's working for me.....

See the attached qvw...

[antoniotiman · Accepted solution]

Calculated Dimension instead of Progress like this

=If(IsNull(Progress),'',Progress)

[0li5a3a]

Thanks Antonio

[0li5a3a]

Thanks Hari, I used Antonio version for my code which works perfect.