Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table as a chart and I want show a different dimension based on user selection.
For ex: if a user picks any date before 06/30/23 I want to display dimension A otherwise Dimension B.
Hi @has35526
You can do this on your script like:
If(YourDate <= '06/30/23' , DimensionA, DimensionB) as NewDimension
Then use the NewDimension in your chart.
You can do this directly in the Chart as well, but when the user selects a value it will show "If(YourDate <= '06/30/23' , DimensionA, DimensionB)" in the selections filter.
Hope this helps
-Zapparoli
https://www.youtube.com/@ZappaAnalytics
Check my Youtube Channel for more Qlik Content
https://www.youtube.com/@ZappaAnalytics
Hi @has35526
You can do this on your script like:
If(YourDate <= '06/30/23' , DimensionA, DimensionB) as NewDimension
Then use the NewDimension in your chart.
You can do this directly in the Chart as well, but when the user selects a value it will show "If(YourDate <= '06/30/23' , DimensionA, DimensionB)" in the selections filter.
Hope this helps
-Zapparoli
https://www.youtube.com/@ZappaAnalytics
Check my Youtube Channel for more Qlik Content
https://www.youtube.com/@ZappaAnalytics