topic Re: Date in QlikView

Date

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Date

Anonymous — Wed, 05 Apr 2017 13:21:13 GMT

Hi John

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

Re: Date

smilingjohn — Wed, 05 Apr 2017 13:30:10 GMT

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

Re: Date

Anonymous — Wed, 05 Apr 2017 13:37:54 GMT

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