topic Re: Month drill down in QlikView

Month drill down

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

Hi ,

I have used Year and Month as drill down group but the drill down is not working means it show only few months for an year.

Ex: If user select 2016 then it went to month drill down and it show all months in 2016.

But in my case it shows only few months.

Note: The chart logic is YTD day wise.

Please find the attached test application.

Thanks.

ahaahaaha — Fri, 31 Mar 2017 11:38:13 GMT

Hi,

Expression of Set Analisys defines a display of only three months in 2016.

Regards,

Andrey

dsharmaqv — Fri, 31 Mar 2017 11:56:47 GMT

Since rest of the month doesnt have data its not appearing in your report

to see all months you have to go

Properties>Dimension> Check Show All values

and

Properties>Presentation>uncheck Supress Zero

hope it helps

hemachandran — Fri, 31 Mar 2017 13:28:37 GMT

hi,

can u try this expression alone

Sum(ESTCUST)

neelamsaroha157 — Fri, 31 Mar 2017 15:13:54 GMT

I think there is issue with the data model or the fields that you are using for Year & Month.

Check out the screen shot.

Can you tell what you exactly want to achieve.