3 Replies Latest reply: May 29, 2017 4:15 AM by Jonathan Studsrød

# Interest days per month

Hi,

I want to show interest days in a table by month in qlik Sense. In january it should be interest/31 days, february/30 days etc. How do I calculate this best in the sqript?

I have tried      if(month={jan,mar,may....31,

if(month={apr,jun,sept....30,

29))

But I only get the correct calculation for either months with 30 or 31..

• ###### Re: Interest days per month

*february/28 days

• ###### Re: Interest days per month

If you have a date field;

in your script; do as this to create a day field and a month field (if it's not already created):

Day([Calendar date]) as [Day of date]

,Month([Calendar date]) as [Month of date]

,date(MonthStart([Calendar date]),'MMM YYYY') as [Year month date]

Now, in your table, you'll have as dimension your [Month of date]field or [Year month date] (if you want to show month and year: depends on the year, Feb could have 28 or  29 days) and as a measure: count(distinct [Day of date])

result: