topic set analysis with multiple distinct in QlikView

set analysis with multiple distinct

venkat1 — Wed, 25 Nov 2020 16:16:04 GMT

getting error if i am writing an expression like below ,can anyone help me in writing an expression with multiple distinct fields .

=sum(Aggr(sum(DISTINCT{<CATEGORY={'D'},D.VOUCHER_NO,D.LABEL_NO>},D.MAKING_SP))

mohamed_ahid — Thu, 24 Oct 2019 09:34:05 GMT

Start by adding a ) in the end .you are missing one .

and the syntaxe is incorrect for the aggr function .it should be something like :

=sum(Aggr(sum(DISTINCT{<CATEGORY={'D'},D.VOUCHER_NO,D.LABEL_NO>}[what you need to sum]),[D.MAKING_SP]))

venkat1 — Fri, 25 Oct 2019 04:52:45 GMT

i had solved by writing like this.

=sum(aggr(sum(DISTINCT {<CATEGORY={'D'}>}D.MAKING_SP),D.VOUCHER_NO,D.LABEL_NO))