topic How to change this query into qlikview expression in QlikView

How to change this query into qlikview expression

Tue, 03 Apr 2012 03:59:13 GMT

How to change this query into qlikview expression.

This is SQL code :

SELECT COUNT(OUTLET_ID) FROM

(SELECT DISTINCT TRX_DATE, OUTLET_ID FROM TABLE_A)

May be someone can help me to make into expression.

Thanks,

Danny H.

CELAMBARASAN — Tue, 03 Apr 2012 04:32:37 GMT

Hi,

Try this

COUNT(Distinct OUTLET_ID&TRX_DATE)

Celambarasan

jagan — Tue, 03 Apr 2012 05:00:12 GMT

Hi,

Use this script

TableName:

SQL SELECT

DISTINCT

TRX_DATE,

OUTLET_ID

FROM TABLE_A;

Count:

LOAD

COUNT(OUTLET_ID) AS OutletCount

RESIDENT TableName;

=Count(OUTLET_ID) use this as expression

Hope this helps you.

Regards,

Jagan.