Discussion Board for collaboration on QlikView Layout & Visualizations.
Sorry, I could not as the data is Sensitive.
It's pretty Straight forward, two dimensions Year and month
Service % is the measure calculated by the formula Supply/Demand per month
YTD is just an extension of that.
I think we might be able to use Synthetic dimensions or Island table dimension to do this. I was just hoping to see how the data is structured to give any suggestions.
You can always scramble your data as mentioned here: Preparing examples for Upload - Reduction and Data Scrambling
Anyways, I will create a sample for you and you can check if this works for you or not
Thanks Clever. I think the dimension and expressions are still not perfect because I am not seeing the accumulation, but it can be further fine-tuned to get the desired result