Expression in pivot table without using Aggr

paolojolly — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone, I need help in pivot table expression.

In my table I have two dimensions (DIREZIONE, ENTE) and as expression I'm trying to use

(
    if(sum(IF(ANNO_DOC = (2018-5) AND MAKEDATE((2018-5) , 1, 1) >= MakeDate(2009, 1, 1) AND 2 = Ceil(MESE_DOC/3) , W_TOT_IMP_RIGA_NETNET, 0)) <> 0, 1, 0) +
    if(sum(IF(ANNO_DOC = (2018-4) AND MAKEDATE((2018-4) , 1, 1) >= MakeDate(2009, 1, 1) AND 2 = Ceil(MESE_DOC/3) , W_TOT_IMP_RIGA_NETNET, 0)) <> 0, 1, 0) +
    if(sum(IF(ANNO_DOC = (2018-3) AND MAKEDATE((2018-3) , 1, 1) >= MakeDate(2009, 1, 1) AND 2 = Ceil(MESE_DOC/3) , W_TOT_IMP_RIGA_NETNET, 0)) <> 0, 1, 0) +
    if(sum(IF(ANNO_DOC = (2018-2) AND MAKEDATE((2018-2) , 1, 1) >= MakeDate(2009, 1, 1) AND 2 = Ceil(MESE_DOC/3) , W_TOT_IMP_RIGA_NETNET, 0)) <> 0, 1, 0) +
    if(sum(IF(ANNO_DOC = (2018-1) AND MAKEDATE((2018-1) , 1, 1) >= MakeDate(2009, 1, 1) AND 2 = Ceil(MESE_DOC/3) , W_TOT_IMP_RIGA_NETNET, 0)) <> 0, 1, 0)
)

But it doesn't work properly(totals in pivot are incorrect)

If I try to use

sum(aggr (

Works properly(totals in pivot are correct)

I would like to use first solution because i want to create a global variable for using in different pivot table that can have different dimensions(without having to change dimensions of the function Aggr for each pivot table)

Can someone help me?

thanks

Re: Expression in pivot table without using Aggr

sunny_talwar — Wed, 07 Feb 2018 13:06:20 GMT

I don't think this is possible

topic Re: Expression in pivot table without using Aggr in QlikView

Expression in pivot table without using Aggr

Re: Expression in pivot table without using Aggr