topic SET ANALYSIS in QlikView

SET ANALYSIS

Sat, 28 Apr 2012 08:35:02 GMT

How to write below statement as SET ANALYSIS?

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

Regards,

Manish

CELAMBARASAN — Sat, 28 Apr 2012 08:44:07 GMT

Hi,

In set analysis -= is <>

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

Celambarasan

Sat, 28 Apr 2012 08:59:52 GMT

NOT WORKING...!

CELAMBARASAN — Sat, 28 Apr 2012 09:39:17 GMT

Hi,

Can you tell me where you used this expression?

Celambarasan

Sat, 28 Apr 2012 10:39:08 GMT

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.

CELAMBARASAN — Sat, 28 Apr 2012 11:02:06 GMT

Hi,

Check with this

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

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

Celambarasan

jagan — Sat, 28 Apr 2012 11:38:26 GMT

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.