Discussion Board for collaboration on QlikView Layout & Visualizations.
I am trying to get the trend in the attached with an up arrow, down etc depending on the max month v previous month.
It has worked for me with a different metric that wasnt a percentage. I think my brackets are wrong but cant seem to fix it.
Any help appreciated.
Table on attached file
Go to Solution.
Changed brackets in if, match and sum comparison clauses, also some brackets left in set analysis, check attachment to see if that's what you are looking for.
View solution in original post
Thank you so much for your time this is perfect.