I have the following measure expression in a table chart field in a QlikView model:
=sum (
total <InvoiceNo>
if (
Value > [Value for Customs],
num(Value,'###0.00'),
num([Value for Customs],'###0.00')
)
)
It sums values dependent on another field, InvoiceNo. Whenever the InvoiceNo field has a new value, it does a new sum. For example:
InvoiceNo Myfield
------------- ----------
1234 546
1234 546
7878 223
7878 223
However I want to recreate this functionality in Qlik Sense and it doesn't work at all. Qlik Sense completely ignores the "total <InvoiceNo>" part of the expression and just gives a grand total on every row (using my example above, it would show 769 on every row of Myfield).
Is there some other syntax that would work?
Thanks
