Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Creator III
Creator III

Date

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

3 Replies
briancopple
Creator II
Creator II

Hi John

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

smilingjohn
Creator III
Creator III
Author

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

briancopple
Creator II
Creator II

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