Discussion board where members can learn more about Qlik Sense App Development and Usage.
Hi I'm trying with no success to make the following master measure visible in all rows of a pivot table
(aggr(sum({1<segmento = -{'ATV','TRICARRI','QUADRICICLI'}> } Quantity), agente,regione))
The output of the measure is correct, but is not visible in all rows, only the first one, see attached image
Under the lombardia dimensios we've got 12 Prov_residenza dimensions, but only on the first row the measure is visible.
Any idea?
Two options
1) Aggr(NODISTINCT Sum({1<segmento = -{'ATV','TRICARRI','QUADRICICLI'}>} Quantity), agente, regione)
2) Sum(TOTAL <agente, regione>{1<segmento = -{'ATV','TRICARRI','QUADRICICLI'}> } Quantity)
no it didn't work, now all of the dimensions are =0
Two options
1) Aggr(NODISTINCT Sum({1<segmento = -{'ATV','TRICARRI','QUADRICICLI'}>} Quantity), agente, regione)
2) Sum(TOTAL <agente, regione>{1<segmento = -{'ATV','TRICARRI','QUADRICICLI'}> } Quantity)
Hi Marco, I think you need to add prov_residenza to your AGGR.
Ciao,
Luigi
Now that I think about it, if you're in a pivot table, you may not need the AGGR,
Just use Sum( {<segmento = -{'ATV','TRICARRI','QUADRICICLI'}> } Quantity)
Cheers
Luis
Hi Luis, that would not suit to my purpose, which is to have a previous level dimension:
I want to see regione's registration units into prov. residenza dimension.
If i added prov residenza I'll get prov residenza registration
Option 1 worked perfectly thanks sunny. How can I mark the question as answered, I',m a rookie in here
Thanks for explaining Marco,
So you wanted, for example, the number 32281 for Lombardia repeated for each prov_residenza in Lombardia? and of course that's why you called it Tot Regione?
Cheers,
Luis