topic Re: Aggregation Help in QlikView

Aggregation Help

ivandrago — Mon, 18 Mar 2013 19:46:10 GMT

Hi,

I have the attached document, I want the value from the text box "Value Required" but I am getting the wrong value based on the chart. I think the reason for this is because there are multi lines for the same ID due to different RuleID.

Thanks

Re: Aggregation Help

srinivasa1 — Mon, 18 Mar 2013 19:58:09 GMT

USe

distinct as below in chart experssion

sum( distinct poPrice* (poQty))

It will show exact value.pls check and let me know

Re: Aggregation Help

ivandrago — Mon, 18 Mar 2013 22:16:00 GMT

Hi,

It does not seem to work, I've attached another document with more data and I have added your expression to the chart "wrong value 2" and the results are not matching the "Value Required" as you can see.

Thanks

Re: Aggregation Help

Mon, 18 Mar 2013 22:25:48 GMT

Try with this:

Sum(Aggr(sum(DISTINCT poPrice * poQty), ID))

Regards,

Ricardo