Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good afternoon,
i've got a problem with this dataset.
If i use the formula sum(VALUE/QUANTITY) i don't get the right sum of price...
What do i need to do?
This the wrong kpy --> it should be 1.113.041
I assume these data aren't loaded within Qlik else exported from there. In this case there are any duplicates within the data which aren't displayed within this table because only distinct combinations of field-values are shown. You could check this by adding a recno() and rowno() to your load and including these fields within your table, too.
- Marcus
Try it with: sum(aggr(sum(VALUE/QUANTITY), customer, code))
- Marcus
I tryed this one:
SUM(AGGR(SUM(DISTINCT FLOOR(VALUE/QUANTITY,0.1)),KEY3))
where KEY3 IS customer & '_' & code in the script area.
This is the best one but not the same as the sum....
I've got many data and doesn't work with all of them...
other ideas?
Thanks
I assume these data aren't loaded within Qlik else exported from there. In this case there are any duplicates within the data which aren't displayed within this table because only distinct combinations of field-values are shown. You could check this by adding a recno() and rowno() to your load and including these fields within your table, too.
- Marcus
how did you calculate 1.113.041 ?