There’s a very complex problem that I have been trying to solve in Qlikview and hitting a brick wall. So Please help!!!
To simplify let’s assume I have following fields:
There could be 1000 assets and data goes back to last 15 years or so. I want to calculate Ratio
User can only select one period i.e.
Qtr to March 2011
Qtr to June 2011
Qtr to Sept 2011
Qtr to Dec 2011
Qtr to March 2012
Qtr to June 2012
6 months to June 2011
Year to June 2011 (going back last 6 months)
I have tried set analysis but to no avail. My last resort is writing a macro. But I don’t know whether I can use set analysis in a macro. Also how do I access particular rows of data in a macro? For example I can load this data into a tablebox but how do I access a particular row or value?
I think what Bilge is asking is what you expect the output to be, and a Straight Chart is a spreadsheet-like object. I think what you need to do here is use a something like "...(Max(Field)-1) in your set analysis. Your expression would be something like...
Max(Field) / (Max(Field)-1)
I don't have the exact sytax, but here is an example of something I've used....