Discussion Board for collaboration related to QlikView App Development.
I have a data set which is the result of a combination of yearly data and monthly data. I have a flag variable and indicator field with 1 and 0 to distinguish them.
The data is like this:
Out of this data I want to see for the maximum of the Year/ Month from selected data. Say If I select 2018,2017 and 2016 then the below table should only be displayed for the Year/ Month
Please explain the formula for the % calculation