topic Current value/previous value thru set analysis help required in QlikView

Current value/previous value thru set analysis help required

rajtechnocraft — Thu, 12 Jan 2012 06:55:26 GMT

Hi Experts, Just wanted help in calculating previous value. I am having sum of sales as my expression It will always show me current value What i want to do is add one more expression which is previous sales . I don't want to do this at script level but at frontend using set analysis The calculation of current /previous value will be based on date selection. Ex if i select today's date then previous should show me yesterdays sale. Pls help. Regards Raj

Current value/previous value thru set analysis help required

SunilChauhan — Thu, 12 Jan 2012 07:10:37 GMT

load

Year ,

peek(Year ) a previous

sales

from path;

in expression

sum({<Year={$(=Only(Year)}>} sales) - current value

sum({<Year={$(=Only(previous)}>} sales) -previous valuee

tab1:

Load

Year,

sales

from path

let var=peek('fieldname',-1,Tablename);

in expression

sum({<Year={$(=Only(Year)}>} sales) - current value

sum({<Year={$(var}>} sales) -previous value

hope this helps

Current value/previous value thru set analysis help required

SunilChauhan — Thu, 12 Jan 2012 07:14:48 GMT

use this for previous calculattion

=sum({<Day= {'$(=Date(max({<Day = {"<$(=max(Day))"}> } Day)))'}>} Price)