Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
marcoserilio
Contributor III
Contributor III

AGGR MEASURE VISUALIZATION PROBLEM

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?

Capture.JPG

1 Solution

Accepted Solutions
sunny_talwar

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)

View solution in original post

7 Replies
marcoserilio
Contributor III
Contributor III
Author

no it didn't work, now all of the dimensions are =0

sunny_talwar

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)

luismadriz
Specialist
Specialist

Hi Marco, I think you need to add prov_residenza to your AGGR.

Ciao,


Luigi

luismadriz
Specialist
Specialist

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

marcoserilio
Contributor III
Contributor III
Author

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

marcoserilio
Contributor III
Contributor III
Author

Option 1 worked perfectly thanks sunny. How can I mark the question as answered, I',m a rookie in here

luismadriz
Specialist
Specialist

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