Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
msmSahaj
Contributor III
Contributor III

Drill Down- Last year, last month, last week

Hi Everyone,

Currently i have Chart based on Year-month.  I have retirement to drill down to last year, last month, last week.

       1. If chart x axis is year then by click on year should display all month.

      2. If chart x axis is month then by click any month should display weeks of that month(min 4 weeks if  3 week completed  month on this month, then previous month last week)

    3. if chart x axis is week then click on any week should display all 7 day. 

Below is my table, I need to calculate based on year-month column.  Please help related this expression.

Thanks 

 

Year-MonthLast WeekLast MonthLast Year
2014-12nonoyes
2014-12nonoyes
2014-12nonoyes
2014-12nonoyes
2014-11nonoyes
2014-11nonoyes
2014-11nonoyes
2014-11nonoyes
2014-11nonoyes
2014-11nonoyes
2014-11nonoyes
2014-11nonoyes
2014-11nonoyes
2014-11nonoyes
2014-10nonoyes
2014-10yesyesyes
2014-10nonoyes
2014-10noyesyes
2015-01yesyesyes
2015-01yesyesyes
2015-01nonoyes
2015-01
Labels (3)
2 Replies
msmSahaj
Contributor III
Contributor III
Author

Hi  @timpoismans can you please check this issue , it with in the previous task 

timpoismans
Specialist
Specialist

Hi there Sahaj

I've been out the last two weeks, so sorry for my late reply.

 

If you have a calendar added to your application, you can create a Master Dimension - Drilldown, which will do exactly what you want.
First it would display all years. Selecting a year would display all months in that year. Selecting a month would display all weeks in that month and selecting a week would display all days in that week.

You'd need to add the [Year]-[Month]-[Week]-[Day] fields from your calendar to the drilldown dimension you're creating.

 

Regards,

Tim P.