variable updation issue

[#1]

Hi all,

I am storing tables count in variables and updating them daily, but the variables which i created always showing first fetched count only,

So kindly need solution to update them for every reload.

I just declaring variables like this

Let vBILLMASTER=NoOfRows('BILLMASTER') ;

..

Thanks in advance

Vijay

[Gysbert_Wassenaar]

Prove it. Please post a qlikview document and some source files that demonstrate this behavior.

[Anil_Babu_Samineni]

Yes, If some one adding the row for your Data source. Absolutely it should work

As Gysbert said, You may prove that. Why it won't work by using scrambling data. So, We may help lot

What you want to count especially. Have you created any inline memory data

[shambhub]

Hi Vijay,

Please write a script like below to store the record count in table on daily bases.

BILLMASTER:

LOAD F1, F2 INLINE [

    F1, F2

    A, 10

    B, 20

    C, 40

    D, 45

];

Let vBILLMASTER=NoOfRows('BILLMASTER') ;

Record_Count:

Load $(vBILLMASTER) as NoOfRows, now() as Date

AutoGenerate(1);

Concatenate

History_Record:

Load NoOfRows, Date From Record_Count.qvd;

Store Record_Count into Record_Count.qvd(txt);