Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the qvw file like the one below. How do I get the average of the count across each row. It's shown in the excel file I'll attach also. I have the count of values grouped by two dimensions. I want to get the average of the count across each row which translates to column1/(column1 + column2). I also want to be able to get the grand total average (shown in excel file) and then eventually filter these calculated values by Dim1 and show it in a text object. Essentially everything in the excel sheet should be in QlikView.
hi
have a look at the attach app