Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zarmoton
Creator
Creator

total of sum distinct in pivot table

hello

please can you help me

i have this output in my QV, which is wrong :

ScreenShot.bmp

but i would like to see that:

ScreenShot.bmp

here is the input file :

and my qvw example

maybe something to change in the pivot table aor/and in the script who load the data

any idea ?

ragrds

thank you for your help

1 Solution

Accepted Solutions
Gysbert_Wassenaar

replace in your second expression sum((DISTINCT amountconso) with sum(aggr(sum(DISTINCT amountconso),codegroupe))


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Gysbert_Wassenaar

replace in your second expression sum((DISTINCT amountconso) with sum(aggr(sum(DISTINCT amountconso),codegroupe))


talk is cheap, supply exceeds demand
zarmoton
Creator
Creator
Author

thk you so much, excellent

and any idea how to filter row in this pivot table where last column show value different than 0 ?

regards