topic Re: Overlapping Week Dimension Issue in QlikView

Overlapping Week Dimension Issue

Zapparoli — Fri, 15 Nov 2024 23:51:13 GMT

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.

Re: Overlapping Week Dimension Issue

FakeJupiter — Thu, 08 Oct 2020 11:57:55 GMT

Hi,

Why don't you just make the new dimension in script?

Re: Overlapping Week Dimension Issue

Brett_Bleess — Thu, 22 Oct 2020 18:40:56 GMT

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