Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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
joonasjaspi
Contributor III
Contributor III

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

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.

joonasjaspi
Contributor III
Contributor III

You can use Quarter-functions to do this:

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

/

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

*100

!