topic Re: updated data is not Refreshing in qliksense in QlikView

updated data is not Refreshing in qliksense

pranali_gawde — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

when I Load daliy basis data in qlik sense.New transactions are load successfully ,but existing transactions with some changes not updated. also it is updated after two days.Can anyone tell me why? or is there any changes in qmc .

Kindly help.

Regards,

Pranali Gawde.

Re: updated data is not Refreshing in qliksense

nasirsaikh — Fri, 19 Oct 2018 06:54:10 GMT

Do full load it will work

Re: updated data is not Refreshing in qliksense

ramasaisaksoft — Fri, 19 Oct 2018 07:06:05 GMT

Hi Pranali,

-->Just go to your script : check your where conditions / incremental load condition you following

-->Check the log files how many records got loaded and compare with table viewer tables.

Re: updated data is not Refreshing in qliksense

pranali_gawde — Fri, 19 Oct 2018 07:07:13 GMT

I always do full Load but updated values not coming it's showes previous value only

Re: updated data is not Refreshing in qliksense

pranali_gawde — Fri, 19 Oct 2018 07:11:59 GMT

I don't find any issue with new transactions .i found that in case any value get alter or update in existing transaction.

Like previously in col: CBM=10

after alter or update in col:CBM=12

after refreshing it shows 10 only not 12.

Re: updated data is not Refreshing in qliksense

ramasaisaksoft — Fri, 19 Oct 2018 07:31:30 GMT

hopefully this issue is because of your incremental load logic.

so please check the incremental logic which u implemented ,

please share ur sample data and expected result so that our folks will help u how to implement incremental load in your script

Re: updated data is not Refreshing in qliksense

pranali_gawde — Fri, 19 Oct 2018 07:40:10 GMT

i am not doing any incremental load .I always do full load .