Discussion board where members can get started with QlikView.
How to write below statement as SET ANALYSIS?
=if(COLUMN1<>'FINAL', if(COLUMN2<>'CREATED', SUM(QTY*Price)))
In set analysis -= is <>
Can you tell me where you used this expression?
I have below table....
COLUMN1 FINAL and COLUMN2 blank means order sent to supplier
COLUMN2 CREATED means order CREATED but not sent to supplier
I need CUSTOMER WISE total where COLUMN 1 is not FINAL and COLUMN 2 is blank means order still need to be created.
Check with this
While loading data in script replace Column2 with empty values as N/A or any other values.
If(Len(Trim(column2)) > 0, Column2, 'N/A') AS column2
Now use this epxression
Hope this helps you.