Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
venkat1
Creator II
Creator II

set analysis with multiple distinct

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))


1 Solution

Accepted Solutions
venkat1
Creator II
Creator II
Author

i had solved by writing like this.

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

View solution in original post

2 Replies
mohamed_ahid
Partner
Partner

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
Creator II
Creator II
Author

i had solved by writing like this.

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

View solution in original post