This is my very first post as being a new user in the community.I have now been experimenting with Qlikview for some time with mixed success. I have found this forum very useful to find answers to challenges that I have been running into.
Currently I am running into a issue for which I have not found any discussion on the community and therefore I sincerely hope you can help me find a solution.
Dashboard requires a graph with a average line. The average is to be determined based on the selected year. The expected result here is a average (single field) based on the previous years. Please see below example:
Explaination of fields in the example
Field selection: represents the selection the user applies on the data displayed on the left;
Expected result: the calculation that is expected to be returned based on the selection;
Expected returned value: the value that will be plotted in the graph.
All fields discussed reside in the same table.
I would expect (in words) that the following is to be included in the expression:
Inverse of the selection of the year < selected year
Until now I have not been able to solve this in any expression (although help function is quite good) and therefore stuck. I hope you can send me in the correct direction!