# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Contributor

## Calculate the value based on above row

Hi All,

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??

1 Solution

Accepted Solutions
MVP

## Re: Calculate the value based on above row

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

`3 * RowNo()`
7 Replies
MVP

## Re: Calculate the value based on above row

May be

`3*Day(Date)`
Contributor

## Re: Calculate the value based on above row

Thank you Sunny. It's working

Contributor

## Re: Calculate the value based on above row

Hi Sunny,

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

MVP

## Re: Calculate the value based on above row

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

Contributor

## Re: Calculate the value based on above row

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.

MVP

## Re: Calculate the value based on above row

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

`3 * RowNo()`
Contributor

## Re: Calculate the value based on above row

Yeah Working thank you!!