Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

SET ANALYSIS

Hi

How to write below statement as SET ANALYSIS?

=if(COLUMN1<>'FINAL', if(COLUMN2<>'CREATED',  SUM(QTY*Price)))

Regards,

Manish

6 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     In set analysis -= is <>

SUM({<COLUMN1-={'FINAL'},COLUMN2-={'CREATED'}>} QTY*Price)

Celambarasan

Not applicable
Author

NOT WORKING...!

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Can you tell me where you used this expression?

Celambarasan

Not applicable
Author

Dear Celambarasan,

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.

COLUMN1COLUMN2Customer NamePART NOQTYPRICETOTAL
CREATEDCUSTOMER 01PART 001686.21422.28
CUSTOMER 02PART 002582.46412.30
FINAL CUSTOMER 02PART 003582.46412.30
FINAL CUSTOMER 02PART 0043209.10627.30
FINAL CUSTOMER 03PART 005401.4758.80
FINAL CUSTOMER 03PART 0061003.87387.00
CREATEDCUSTOMER 03PART 007204.6092.00
CUSTOMER 03PART 008204.8797.40
FINAL CUSTOMER 03PART 009505.21260.50
FINAL CUSTOMER 03PART 0101504.57685.50
CUSTOMER 04PART 01120049.509900.00
CUSTOMER 04PART 01230649.5015147.00
CUSTOMER 04PART 0135040.842042.00
CUSTOMER 05PART 0142013.54270.80
FINAL CUSTOMER 05PART 0151028.09280.90
CUSTOMER 05PART 016403.17126.80
FINAL CUSTOMER 05PART 017254.30107.50
FINAL CUSTOMER 05PART 018205.55111.00
FINAL CUSTOMER 06PART 01912.072.07
FINAL CUSTOMER 06PART 0201188.86188.86
CREATEDCUSTOMER 06PART 0215127.24636.20
CREATEDCUSTOMER 06PART 0225127.95639.75
CUSTOMER 06PART 023276.34152.68
FINAL CUSTOMER 06PART 024174.4674.46
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Check with this

    

SUM({<COLUMN1-={'*'},COLUMN2-={'*'}>} QTY*Price)

or

SUM({<COLUMN1={''},COLUMN2={''}>} QTY*Price)

Celambarasan

jagan
Luminary Alumni
Luminary Alumni

Hi,

While loading data in script replace Column2 with empty values as N/A or any other values. 

LOAD

     column1,

     If(Len(Trim(column2)) > 0, Column2, 'N/A') AS column2

FROM DataSource;

Now use this epxression

SUM({<column1-={'FINAL'},column2={'N/A'}>} QTY*Price)

Hope this helps you.

Regards,

Jagan.