Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone!
I have a calculated dimension (made by script witch is Salesman + Week) as SalesmanWeek that returns the information of all salesman by each week.
When i have a Week selected in my panel (by rule i will always have it) the filter will also get applied to SalesmanWeek as expected and will return only information of that week.
How can i avoid that from happening, since i'm using SalesmanWeek as a Dimension in my Graph ?
Note that i'm using in expression level a Set Analysis to Ignore the week already, witch is working fine but i can't find the right way to do that in the Dimension.
The reason i'm doing this it's because i'm trying to generate a report in Nprinting, and for each slide it will have the Salesman and the Week, so i make a pagination and get the Invalid Selection Issue, because the Week is overlapping, and when i remove the week selection, it works fine.
Thanks.
-Matheus.
Check my Youtube Channel for more Qlik Content
https://www.youtube.com/@ZappaAnalytics
Hi,
Why don't you just make the new dimension in script?
Only thing that came to mind was you likely need to use AGGR function in the expression to incorporate the dimension aspect you need, not sure, but figured it was worth a shot:
https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822
Regards,
Brett