Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

help on formula

Re: Help regarding carryon count of tickets

Hi all please go throught the above post that i want help on  ,,

i am trying something like this to get the carry forward tickets for every month , when it is month end i wan to calculate the total tickets  total tickets that are still active and total of tickets that is carry forward to next month as they are not resolved


In the above jun month has the total tickets as 163 out of which 143 are resolved and 20 will go as the carry forward so it has to be added to the count of total tickets in may as may total tickets are 423 and carry farward are 20 it has to be 443 and the the resolved is 416 so at the end of month the carry farward has to be 443-416 =27 ,this 27 has to be added to the next month and so onn,,

one more thing i took the data from Nov 2015 to june-2016 but when i took it as the load order it is not coming in that way ,i want it to be as NOV,DEC,JAN,FEB,MAR,APR,MAY,JUN

Thanks everyone in advance

2 Replies


I have tried with above() function.

please check and let me know ...

Contributor III
Contributor III

Hi Allu,carrypic3.PNG

in the above screenshot the carry farward is not correct for may

the results has to be like