Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to list the data that match the user selection, Then use the list as a Chart dimensions

Hi

I am trying to create a Chart, That will show the This year(TY) , Last Year(LY), and This Year Budget for the each weeks that allocated in the user select week' Month.

For example, in dim_calendar, there are 53 weeks and 12 month in a year. Some month has 4 weeks some month has 5 weeks.

If user select weeks 22. this week belongs to month 05. and in this month there are 4 weeks, which are week 19,20,21,22.

So the user want to see TY sales, LY sales and This Year Budget for these 4 weeks each.

Capture.GIF.gif

Capture.GIF.gif

the WK1=weeks 19, WK2=weeks20, WK3=weeks 21, WK4=weeks22.

So, how to build the chart dimensions that can list the weeks based on the user selection?

Thanks a lot

0 Replies