Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
ADDAS
Contributor
Contributor

Chart with fixed date range but detail shd be dynamic

Hi, We have one dashboard where we have default parameters Year is set to current and last year (2022,2021).

We have one bar chart to show top 10 revenue and another chart to show revenue against Months, another chart with salesperson. All working fine.

Requirement is now changed, we need to show top 10 revenue for last month only as fixed and other chart should show as per default year selection dynamic.

If user selects the revenue bar, then next two chart should show all details linked to that revenue.

Basically user want to see the previous trend of top revenue generator's of last month.

It may be easy stuff for experts, i am new. Thanks in advance for your help with some code scripts.

Labels (1)
1 Reply
Vijayqlik4171
Contributor III
Contributor III

=sum({<revenue= {"=rank(sum(revenue))<=10"},Month={=max(monrth)-1}>}revenue)