topic Re: How to ignore dimension for sum in expression in Qlik Learning Discussions

How to ignore dimension for sum in expression

Tue, 17 Mar 2015 09:15:08 GMT

Hello,

I want make a sum in a expression but a join in my load script duplicate some data, for example

id;mynumber;otherid,somedataofotherid

1;25;87;somedata1

1;25;88;somedata2

How to sum mynumber and have 25 for result, I want to ignore otherid and somedataofotherid ? I have also lot of filter and i use lot of if to filter my data

Perhaps it's not possible ?

Thanks in advance

Christophe

Re: How to ignore dimension for sum in expression

Gysbert_Wassenaar — Tue, 17 Mar 2015 09:28:53 GMT

Try sum({<otherid=,somedataofotherid=>}distinct mynumber)

Re: How to ignore dimension for sum in expression

Tue, 17 Mar 2015 11:27:32 GMT

Thank you for the response but unfortunatly it does not work for me.

Please find enclosed test project,

Your solution is working if I use distinct in expression, but if I add an other id to keep I want to have 50 for result (25 for otheridtokeep = 8 + 25 for otheridtokeep = 9) for id_statut = 1 (and not 75)

datatest:
LOAD * INLINE [
id_statut, mynumber, otherid, otheriddata, otheridtokeep
1, 25, 58, otherdata1,8
1, 25, 87, otherdata2,8
1, 25, 87, otherdata2,9
2, 41, 48, otherdata3,1
2, 41, 46, otherdata4,2
3, 25, 49, otherdata5,3
3, 24, 57, otherdata6,4
];

Thanks for your help.

Christophe

Re: How to ignore dimension for sum in expression

Gysbert_Wassenaar — Tue, 17 Mar 2015 11:37:37 GMT

Try sum(aggr(sum(distinct mynumber),id_statut,otheridtokeep))