Deviation Logic issue.

[Rkbangari]

Hello Qlik Developer,

Currently im facing issue with one calculation. Please see below,

In a monthly(Column A) data, Sources(Column B) have its values are given in Quarterly and sum of total value is given in Total 22 QTR(Column Y). Now i want to show the totals of Jan data to the rest of the months totals as Jan --- Manually added values in Deviation(Column AA).

Please find the attached Sample data set.

[Rajashekar]

here is one thought..

you can take Jan data into new table and left join it to main table based on Sources column with different name. So it will be added to all months.

then you can easily subtract and get the data you want.. just some thought you can try out.. 🙂 

Jan	Assets	112.59
Jan	Addon	511961.7
Jan	Balance	512074.5
Jan	Liquity	100.88

Date		Total 22 QTR		Test1
Jan	Assets	112.59	Left join	112.59
Jan	Addon	511961.68		511961.7
Jan	Balance	512074.47		512074.5
Jan	Liquity	100.88		100.88
Feb	Assets	75.77		112.59
Feb	Addon	476766.65		511961.7
Feb	Balance	476842.42		512074.5
Feb	Liquity	67.97		100.88
Mar	Assets	68.58		112.59
Mar	Addon	481163.29		511961.7
Mar	Balance	483728.27		512074.5
Mar	Liquity	-75.27		100.88