Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

SET ANALYSIS

Hi,

     In set analysis -= is <>

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

Celambarasan

Not applicable

SET ANALYSIS

NOT WORKING...!

SET ANALYSIS

Hi,

     Can you tell me where you used this expression?

Celambarasan

Not applicable

SET ANALYSIS

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

SET ANALYSIS

Hi,

     Check with this

    

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

or

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

Celambarasan

MVP
MVP

SET ANALYSIS

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.