Discussion Board for collaboration related to QlikView App Development.
I'm new Qlikviewer, Please help me
My problem is I can't Distinct and sum value T_T
My data is
I want to distinct ID and sum MONEY
so sum money is 500+300+300+500 = 1600 from distinct ID
and I want to use codes in Expression on Graph object
Thank you and Sorry for my English language
But you may want to fix your data model to remove the duplicates.
Hi, Amornsak Nakvisut.
Another suggestion is, you can treat the script. See example below.
LOAD * Inline [
DROP TABLE VALUE;
Hope this helps!