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

    Interest days per month

    Jonathan Studsrød

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