Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
marishnagendran
Contributor

Calculate the value based on above row

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

1 Solution

Accepted Solutions

Re: Calculate the value based on above row

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

3 * RowNo()

View solution in original post

7 Replies

Re: Calculate the value based on above row

May be

3*Day(Date)
marishnagendran
Contributor

Re: Calculate the value based on above row

Thank you Sunny. It's working

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

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?

marishnagendran
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.

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

 

 

Re: Calculate the value based on above row

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

3 * RowNo()

View solution in original post

marishnagendran
Contributor

Re: Calculate the value based on above row

Yeah Working thank you!!