Calculate the value based on above row

[marishnagendran]

Hi All,

Kindly please find the attachment.

In that there is a column overheads, At every first month i have enter one value (e.g) value is 3.

Based on that 3 value 2 day it shows 6 and 3rd day it shows 9.

It will automatically calculate till last month

Is there any function in qliksense?? 

[sunny_talwar]

May be

3*Day(Date)

[marishnagendran]

Thank you Sunny. It's working

[marishnagendran]

Hi Sunny,

One doubt if it is Sunday or holiday your logic won't work.Any function is there??

[sunny_talwar]

Not sure I understand... why won't it work? Sunday or Holiday also have a day number to it... don't they?

[marishnagendran]

For Example:

Date	Sum(Sales)	Overheads	Total
01-Apr-19	20	3	17
02-Apr-19	30	6	24
05-Apr-19	32	9	23

Above Example :

Assume 03-Apr-2019, 04-Apr-2019 Holiday

For 05-Apr-2019 the over heads value will be 9.

but if i implement your logic it shows 15 as overheads.

[sunny_talwar · Accepted solution]

Are you looking at one month at a time? May be try this

3 * RowNo()

[marishnagendran]

Yeah Working thank you!!