How to change this query into qlikview expression

[#1]

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 · Accepted solution]

Hi,

     Try this

     COUNT(Distinct OUTLET_ID&TRX_DATE)

Celambarasan

[jagan]

Hi,

Use this script

TableName:

SQL SELECT

     DISTINCT

     TRX_DATE,

     OUTLET_ID

FROM TABLE_A;

Count:

LOAD

     COUNT(OUTLET_ID)  AS OutletCount

RESIDENT TableName;

OR

=Count(OUTLET_ID) use this as expression

Hope this helps you.

Regards,

Jagan.