Discussion Board for collaboration related to QlikView App Development.
Hi can any help me to do
in the below attached screen shot
how to calculate the last 3 years average.Which expression we have to write for count of Last 3 years average.
and how to calculate the "36 months rolling Avg".
I have Year,Month for count MAINID Field are their .
This is the pivot table i was built in qlikview.My requirement is i need to find out the last 3years average i.e
My dimensions are statusdate year,statusdate month
How to find the 3years average for this table
I have another requirement i.e calculate the Median Reponse Time.I have attached the sample qvw file.Please find the below.
I have Two fields AR_SEC,S_SEC.need to calculate he median response time for these two fields.
The output like for priority1 -->6.08 minutes.Please help me to calculate the median response time.