topic Re: Chart Selection and calculated Dimension in App Development

Chart Selection and calculated Dimension

manoranjan_321988 — Fri, 22 Aug 2025 20:51:46 GMT

"Hello all,

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

Users can only select one time frame (Year, Month-Year, Week, Day) using the interactivity setting, allowing removal and selection flexibility.
On opening the sheet, the Month-Year filter automatically selects completed months (e.g., July-2025).
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!"

Re: Chart Selection and calculated Dimension

manoranjan_321988 — Fri, 22 Aug 2025 19:45:47 GMT

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

Re: Chart Selection and calculated Dimension

manoranjan_321988 — Sat, 23 Aug 2025 04:10:38 GMT

@olofmalmstromor qlik expert any help on this

Re: Chart Selection and calculated Dimension

hanna_choi — Mon, 25 Aug 2025 01:32:39 GMT

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.

Re: Chart Selection and calculated Dimension

manoranjan_321988 — Mon, 25 Aug 2025 10:19:38 GMT

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

Re: Chart Selection and calculated Dimension

manoranjan_321988 — Mon, 25 Aug 2025 11:10:06 GMT

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.

Re: Chart Selection and calculated Dimension

manoranjan_321988 — Tue, 26 Aug 2025 05:30:02 GMT

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

Re: Chart Selection and calculated Dimension

manoranjan_321988 — Tue, 26 Aug 2025 05:33:46 GMT

@olofmalmstrom any help on this

Re: Chart Selection and calculated Dimension

olofmalmstrom — Tue, 26 Aug 2025 07:05:04 GMT

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.

Re: Chart Selection and calculated Dimension

manoranjan_321988 — Tue, 26 Aug 2025 19:36:25 GMT

@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

Re: Chart Selection and calculated Dimension

manoranjan_321988 — Wed, 27 Aug 2025 07:51:26 GMT

@olofmalmstrom any help or solution on this issue of invalid parameter