This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
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 .
share some sample data and expected output here.
Addmonths works when Data format is YYYY-MM-DD.
Avg( Aggr( Sum(MAINID ), Month) )
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
So instead of seeing 110 for Year = 2016 and Month = Jan, you would want to see 104? and similarly each cell will be made up of 3 year's average for the same cell?
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.