Solved: How to get count?? - Qlik Community

Report Inappropriate Content · ‎2013-02-04

I am loading only one column from Qvd

Orders:

Load Order_No

From c:\ORD.qvd(Qvd);

I want to get the cont of distinct Orders_No into script and store in the variable at the script level only.

Hoe to do this?

Thanx in Advance..!!

Report Inappropriate Content · ‎2013-02-04

Hi, you need to load your table in temporary table usuing COUNT(DISTINCT YOUR_VALUE).

To read the value and insert into a variable, use the function PEEK;

Ex.:

Orders:

Load Order_No

From c:\ORD.qvd(Qvd);

NOCONCATENATE

TMP:

LOAD COUNT(Distinct Order_No) AS Qty

RESIDENT Orders;

LET vQty = PEEK('Qty', 0, 'TMP');

DROP TABLE TMP;

Report Inappropriate Content · ‎2013-02-04

Hi, you need to load your table in temporary table usuing COUNT(DISTINCT YOUR_VALUE).

To read the value and insert into a variable, use the function PEEK;

Ex.:

Orders:

Load Order_No

From c:\ORD.qvd(Qvd);

NOCONCATENATE

TMP:

LOAD COUNT(Distinct Order_No) AS Qty

RESIDENT Orders;

LET vQty = PEEK('Qty', 0, 'TMP');

DROP TABLE TMP;

Anonymous · ‎2013-02-04

Hi,

Please check the application,by using peek function you can take value into variable.

Regards

Report Inappropriate Content · ‎2013-02-04

Thnx.. It is perfect..

Anonymous · ‎2013-02-04

Sorry,

Please find the attachment of applicatio,

Regards

How to get count??