Date

[smilingjohn]

HI All,

Can please someon help me with this .i have a month in which there are some date missing ...and in the output i want to show something like that , if there is no date , then the count for that date selected should be zero .........

for exmaple consider there is one month say Feb , and the date range is from

i want a query where upon if there is not date for this month say the data is not available for 4th Feb , and during this it has to consider it as zero, when i select 4th feb in the calendar and the lead .

Thanks

[Anonymous]

Hi John

Have you tried un-ticking the suppress zero checkbox on the chart presentation tab?

[smilingjohn]

I cant do that becuase iam selecting the values from a calendar , in qlikview

and i want to use the above logic while ftching the data from DB in QVD's

[Anonymous]

Can you share a sample app to highlight your issue please and I'm sure we can provide an answer for you.