Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using current position in the year to make a calculation

Hi,

I need to show at the top of my dashboard, Planned Sessions (for the year) and Actual Sessions (for the year). The planned sessions is just a yearly figure for each consultant taken from a spreadsheet and the actual is a count of the session ids that have actually taken place. I need to show depending on the current date in the year what the consultant should have completed so far regarding the plan...

So, it is currently 3 months into the current year, the yearly figure is e.g. 120 so he should have completed 30. Is this possible?

Many Thanks,

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Probably yes.

Maybe like

=round((today() - YearStart(today(),0,4) ) / 365 * 120)

where the third argument to yearstart() defines your financial year start (here: April).

View solution in original post

4 Replies
swuehl
MVP
MVP

Are you looking for something like

=month(today() ) / 12 * 120

Not applicable
Author

Is there anyway to do it using financial year?

swuehl
MVP
MVP

Probably yes.

Maybe like

=round((today() - YearStart(today(),0,4) ) / 365 * 120)

where the third argument to yearstart() defines your financial year start (here: April).

Not applicable
Author

Thanks thats works perfectly.