topic Re: How to get count?? in QlikView

How to get count??

Mon, 04 Feb 2013 18:17:58 GMT

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..!!

Mon, 04 Feb 2013 18:31:55 GMT

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 — Mon, 04 Feb 2013 18:40:34 GMT

Hi,

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

Regards

Mon, 04 Feb 2013 18:41:37 GMT

Thnx.. It is perfect..

Anonymous — Mon, 04 Feb 2013 18:41:57 GMT

Sorry,

Please find the attachment of applicatio,

Regards