Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have a line chart with Dimension as : Date and expression as Sum({<[Internal-External]={'Internal'}>}Sales).
Is it possible in qlik sense that when user select an expression value in the line chart (Say suppose 2000$ which is coming against dimension value 28th Jun 2022) then user should automatically moved to Raw data sheet with following filters applied so that he/she can get the underline data for the value they have selected on the line chart (in this ex. 2000$)?
Filters to be applied : Date : 28th Jun 2022 and [Internal-External]: 'Internal'
Many thanks
As far as I know, this is not possible for two reasons:
1) There's no way to trigger a sheet change by clicking a specific value within a line chart
2) Clicking a value will select the associated dimensions, not additional filters contained within an expression's set analysis
You could perhaps work around this by adding a button to perform both actions - selecting "Internal" and changing sheets - which the user would click after making a selection within the chart.
Agree, I was also of the same opinion but thought of checking with the wider Qlik sense developer group.
many thanks for your reply.