topic Re: set analysis dimension month in QlikView

set analysis dimension month

rafael_neves — Fri, 19 Oct 2018 15:27:12 GMT

Hello.

I have a function that ignores the dimension of month when I put it in a graphic.

how do I for this part of the function consider the dimension that is displayed?

I will use as an example the month of October

without filter the graphic marks a number of 301

with filter in October o Graph mark 529 (Correct Number)

I think I'm missing out on this part.

Count({<CUS_CUST_ID={'=SUM(LL_Maximo_Mes)=0'},PACKAGE_CONTENT={'publications'} >} distinct CUS_CUST_ID)

Thanks a lot for the help

Re: set analysis dimension month

juraj_misina — Fri, 02 Nov 2018 23:11:39 GMT

Hi,

When you select a month, only that month is considered for your set analysis. So in October there are 529 customers with Sum(LL_Maximo_Mes)=0. But some of those customers can have Sum(LL_Maximo_Mes)<>0 in other months, therefor they are excluded by your set analysis. I don't think you can solve this with set analysis, I think you'll need Aggr for this. Something like

Count({<PACKAGE_CONTENT={'publications'} >} If(Aggr(Sum(LL_Maximo_Mes), Month, CUS_CUST_ID)=0, distinct CUS_CUST_ID)

Hope this helps.

Juraj

Re: set analysis dimension month

rafael_neves — Sun, 07 Apr 2019 11:38:44 GMT

Thanks for help.

I found the answer by placing an if inside Aggr

sum(
Aggr(
if(
Count({<Content={'publications'}>} distinct Cust)=1
and sum(LL)=0
,1,0),
Cust, Ano_Mes
)
)