Chart Selection and calculated Dimension

[manoranjan_321988]

"Hello all,

Please find attached my sample data and QVF file. All requirements were implemented as expected:

1. Users can only select one time frame (Year, Month-Year, Week, Day) using the interactivity setting, allowing removal and selection flexibility.
2. On opening the sheet, the Month-Year filter automatically selects completed months (e.g., July-2025).
3. The chart displays a 12-month rolling period using completed months by default, with dynamic dimension switching based on selected time frame. The lowest granularity chosen by the user drives the chart dimension, handled via calculated dimensions and set analysis expressions.

Current Issue: After a user logs in and selects a month (e.g., July-2024) in chart, chart logic works correctly. However, if they clear filters and select a new month (e.g., February-2024) in the chart, the chart dimension reverts to a cached value (week start date of July-2025) instead of updating properly. Please advise on resolving this caching issue.

Thank you in advance!"

[manoranjan_321988]

@olofmalmstrom  or any Qlik tech expert any help and solution on this will be much appreciated 

[manoranjan_321988]

@olofmalmstromor qlik expert  any help on this 

[hanna_choi]

Hello @manoranjan_321988 

I download your app.
The app is included the extension filters.
When I use Qlik filter panel, All selection action is done well.

How about you will change from extension filter to Qlik filter Pane?

I could not test the extension filter because I can not download the extension filter zip.

Best Regards.

[manoranjan_321988]

Qlik filter pane i cant change it bcoz we have default setting in the month year filter and time frame filter pane has to be consistency to use vizlib,

to get vizlib extension u need   download put it in the local folder sense

only issue is  when u  open  the dashboard first  and select in the chart dimension filter for July2025 in the chart , as per the calculated dimension its working fine for july2025  and then clear all filter  and select the chart dim for May2025 or Aug2025 or any(Month year expect the july2025) this will point to the pervious selection  of july 2025 and drill to july 2025 only

[manoranjan_321988]

some  what 90 % i achieved the solution changing the top filter to with aggr function,

now some times i getting invalid parameter error code 8 in the front end ,wht i observed is top filter are single selection in the sheet which is declared in the vizlib filter setting  and qlik engine select the multiple dates at the lowest granularity as per the chart cal dim 

any solution  for the error code 8 much welcome and thanks. PFA of revised QVF and error screen shot.

[manoranjan_321988]

Hi team any help on this invalid parameter when we select year filter 2025 in top filter panel  vizlib and then clicking  the chart  bar for another year example  2023 , it's getting drill down till chart cal dim of the lowest date granularity .

at that time invalid parameter error is coming 

Any help

[manoranjan_321988]

@olofmalmstrom any help on this

[olofmalmstrom]

If I remember correct, we have talked about this before, you don't want the users to make selections in a calculated dimension as it it will make selections in all the fields involved in the dimension calculation.

[manoranjan_321988]

Spoiler

Spoiler

@olofmalmstrom @    Yes long back u helped on cal dim, now user said to stick one selection in filter panel and then he ll see the chart click the chart dimensions value there it is getting failed, due to invalid parameter error that prompt msg user won't accept it

Any help on this