topic Re: Issue in set analysis in QlikView

Issue in set analysis

Fri, 15 May 2015 18:05:08 GMT

Hi,

Can someone please tell me what is the issue in this set analysis expression.

sum({<[Order Line Item Type Code]={'STANDARD','MODEL'},match([Order Type]={*WARRANTY*,*AFTERMARKET*,*RETURNS*})>}[Unit Price])

Thanks in advance.

Regards,

Adi

Gysbert_Wassenaar — Fri, 15 May 2015 18:06:56 GMT

This is: match([Order Type]={*WARRANTY*,*AFTERMARKET*,*RETURNS*})

You can onky use field names on the left side of the =, not expressions.

Try: sum({<[Order Line Item Type Code]={'STANDARD','MODEL'},[Order Type]={'*WARRANTY'*,'*AFTERMARKET'*,'*RETURNS*'}>}[Unit Price])

Fri, 15 May 2015 18:09:37 GMT

Sorry, it should ahve been match not equal to