Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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??
May be
3*Day(Date)
Thank you Sunny. It's working
Hi Sunny,
One doubt if it is Sunday or holiday your logic won't work.Any function is there??
Not sure I understand... why won't it work? Sunday or Holiday also have a day number to it... don't they?
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.
Are you looking at one month at a time? May be try this
3 * RowNo()