topic Re: variable updation issue in QlikView

variable updation issue

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: variable updation issue

Gysbert_Wassenaar — Mon, 05 Dec 2016 07:10:29 GMT

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

Re: variable updation issue

Mon, 05 Dec 2016 07:16:55 GMT

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

Re: variable updation issue

Gysbert_Wassenaar — Mon, 05 Dec 2016 07:19:41 GMT

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.

Re: variable updation issue

Anil_Babu_Samineni — Mon, 05 Dec 2016 07:20:43 GMT

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') ;

Re: variable updation issue

Mon, 05 Dec 2016 07:23:16 GMT

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

Re: variable updation issue

Mon, 05 Dec 2016 07:24:30 GMT

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

Re: variable updation issue

Mon, 05 Dec 2016 07:26:07 GMT

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

Re: variable updation issue

Gysbert_Wassenaar — Mon, 05 Dec 2016 07:29:46 GMT

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.

Re: variable updation issue

Mon, 05 Dec 2016 07:32:39 GMT

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

Re: variable updation issue

Gysbert_Wassenaar — Mon, 05 Dec 2016 07:35:45 GMT

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

Re: variable updation issue

Anil_Babu_Samineni — Mon, 05 Dec 2016 07:40:40 GMT

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

Re: variable updation issue

shambhub — Mon, 05 Dec 2016 08:14:40 GMT

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);