Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
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
Partner - Champion III
Partner - Champion III

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.