Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

qvhelpplease
New 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

Commpic1.PNG

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

Tags (1)
2 Replies
galax_allu
Valued Contributor

Re: help on formula

hI

I have tried with above() function.

please check and let me know ...

Highlighted
qvhelpplease
New Contributor III

Re: help on formula

Hi Allu,carrypic3.PNG

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

the results has to be like

Comminflow3.PNG