Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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 - Specialist
Partner - Specialist

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