Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
ravindraa
Creator
Creator

How to get the distinguish value from last reload and current reload

Hi experts,

  i have struct one place please help to come out , my requirement is i have to find out the distinguish values from last reload and current reload.

  as per the attached file we can get sum(sales) =2452.. after add 2 or 3 values then we have to reload the application ,here i have to display the how many sales added to particular ID from last reload to current reload.

thanks in advance

2 Replies
Gysbert_Wassenaar

It sounds like you want to implement incremental loading. If that's correct try reading some discussions about this: https://community.qlik.com/search.jspa?q=incremental+loading.

And these blog posts:

http://www.quickintelligence.co.uk/qlikview-incremental-load/

Incremental Load using Qlikview Components | Qlikview Cookbook

Qlik Tips: Easy incremental load

Creating A QlikView Incremental Load | qlikcentral


talk is cheap, supply exceeds demand
ravindraa
Creator
Creator
Author


Hi Gysbert,

  Sorry for late reply and thank you very much for reply , actuvaly if the perticular ID(101) sold 10 items at  5/18/2015 and same ID person has sold 20 items at 5/19/2015. so the difference is 10

the table need to display like below

ID , sum(sales), difference (previous sold date - today sold date).

101, 30, 10

it should display like...

Kindlyl help me out.