Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
i have the following data with Month names and the corresponding %. i have to build a chart/table with Month name as dimension and two expressions 1. Current Month % as it is 2. Previous six months average.
For example, if the Month name is September-2019, then current month % is 86.69% and Previous six months average should be 85.03%. can you please help me with the expression? i cannot do this in the data.
Input:
Month Year | Current Month % |
01-2019 | 84.81% |
02-2019 | 83.94% |
03-2019 | 84.43% |
04-2019 | 84.51% |
05-2019 | 86.25% |
06-2019 | 85.86% |
07-2019 | 85.19% |
08-2019 | 85.07% |
09-2019 | 86.69% |
10-2019 | 85.50% |
11-2019 | 87.09% |
Look at my response here
https://community.qlik.com/t5/New-to-QlikView/expression-for-rolling-six-months/td-p/1647884