Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum of rows in pivot table

here is an expression that i am using in a pivot table and even if i try to use the aggr i am not getting the desired result, can someone advise on this please?

if([AGFB]='ALL OTHER',[PY GS],sum({< Flag_Std = {'1'} >} Bdt*$(v_RptSel1))/1000)

in this expression

[PY GS]- is an another expression label name.

4 Replies
richard_pearce6
Partner - Specialist
Partner - Specialist

Hi Dinesh,

Can you post your QVW so we can see the dimensions you're using in your chart.

Have you tried 'show partial sums' in the presentation tab of the chart properties?

Richard

qlikcentral.com

Not applicable
Author

Never mind i figured it.

The way i did this is instead  of using the column label [PY GS] i used the whole expression with Sum(aggr(expresssion,DIM1,DIM2)) and it worked.

Greg_Williams
Former Employee
Former Employee

Few suggestions:

1. Bdt*$(v_RptSel1))/1000)  > Bdt * $(v_RptSel1) - space it out a bit, especially with *

2. Is the Flag a text or a number? '1' vs 1 for < Flag_Std = {'1'} >}

3. consider =$ for dollar sign expansion.

Hope this Helps.

~Greg

Not applicable
Author

Thanks Greg williams.