Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
nareshthavidishetty
Creator III
Creator III

Month drill down

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.

4 Replies
ahaahaaha
Partner - Master
Partner - Master

Hi,

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

Regards,

Andrey

dsharmaqv
Creator III
Creator III

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
Partner - Creator
Partner - Creator

hi,

can u try this expression alone

Sum(ESTCUST)

neelamsaroha157
Specialist II
Specialist II

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

Check out the screen shot.

Capture.PNGCapture1.PNG

Can you tell what you exactly want to achieve.