https://community.qlik.com/t5/App-Development/Chart-with-fixed-date-range-but-detail-shd-be-dynamic/m-p/1901551#M74381 <P><SPAN>=sum({&lt;revenue= {"=rank(sum(revenue))&lt;=10"},Month={=max(monrth)-1}&gt;}revenue)</SPAN></P> Sun, 06 Mar 2022 06:06:58 GMT Vijayqlik4171 2022-03-06T06:06:58Z https://community.qlik.com/t5/App-Development/Chart-with-fixed-date-range-but-detail-shd-be-dynamic/m-p/1901511#M74373 <P>Hi, We have one dashboard where we have default parameters Year is set to current and last year (2022,2021).</P> <P>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.</P> <P>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.</P> <P>If user selects the revenue bar, then next two chart should show all details linked to that revenue.</P> <P>Basically user want to see the previous trend of top revenue generator's of last month.</P> <P>It may be easy stuff for experts, i am new. Thanks in advance for your help with some code scripts.</P> Sat, 05 Mar 2022 12:10:28 GMT https://community.qlik.com/t5/App-Development/Chart-with-fixed-date-range-but-detail-shd-be-dynamic/m-p/1901511#M74373 ADDAS 2022-03-05T12:10:28Z https://community.qlik.com/t5/App-Development/Chart-with-fixed-date-range-but-detail-shd-be-dynamic/m-p/1901551#M74381 <P><SPAN>=sum({&lt;revenue= {"=rank(sum(revenue))&lt;=10"},Month={=max(monrth)-1}&gt;}revenue)</SPAN></P> Sun, 06 Mar 2022 06:06:58 GMT https://community.qlik.com/t5/App-Development/Chart-with-fixed-date-range-but-detail-shd-be-dynamic/m-p/1901551#M74381 Vijayqlik4171 2022-03-06T06:06:58Z