Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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)