Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
viveksairam89
Creator
Creator

Current Month count of days

Hi,

I want to establish the Monthly percentage

for example Today date is 22 june2017

22 days

current June month days is = 30 days

* 100 to calculate the percentage

Calculations:

22/30*100=73.33% it should be

4 Replies
Anonymous
Not applicable

Replace today() with your datefield

=day(today())/day(monthend(today()))*100

viveksairam89
Creator
Creator
Author

Thanks for the quick response

If i want to get for Quarter wise monthly percentage ca you help me out

henrikalmen
Specialist
Specialist

Use a "master calendar" in your application to get quarter as a dimension to calculate by. Take a look for example at Creating A Master Calendar or at The Master Calendar.

Anonymous
Not applicable

You can use Quarter-functions to do this:

=(today()-QuarterStart(today()))

/

floor((QuarterEnd(today()))-QuarterStart(today()))

*100

!