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]

If you declare the variables at the end of the script they will get the updated row count values of the tables.

[#3]

doing the same thing .....but i am same count .... my scenario  is when i do another new records will so tables count also increase ...my problem is when i do second and third reloads also first time reload what was taken to variables same thing it is showing....

[Gysbert_Wassenaar]

Then perhaps you're not adding any data to the tables. Or you're not using the correct case sensitive table names. Or the data is ending up in another table because that table has the exact same layout as the data you load.

[Anil_Babu_Samineni]

For me this is working to show the value, For below i've check the Text object it will give 4. And i had update the value and added. It will update successfully. Can you share what are you expecting

BILLMASTER:

LOAD F1, F2 INLINE [

    F1, F2

    A, 10

    B, 20

    C, 40

    D, 45

];

Let vBILLMASTER=NoOfRows('BILLMASTER') ;

[#6]

i am not telling content i am storing only tables records count to the variables......if did like that the count of records in tables need to change know after two days also same tables count showing but actually records count need to be change right...

[#7]

if new record inserted the variable count also increasing wright...

[#8]

And also all those variables values for each day count need to store in table by creating fields for them ...

[Gysbert_Wassenaar]

If you don't load data then there's nothing to count. The NoOfRows function only works on tables in Qlikview's internal in-memory database.

[#10]

Data is loading actually  the calculation values also changing but count of the records not changing.