Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi John
Have you tried un-ticking the suppress zero checkbox on the chart presentation tab?
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
Can you share a sample app to highlight your issue please and I'm sure we can provide an answer for you.