Discussion Board for collaboration on QlikView Scripting.
Can anyone tell me how I can show the change from the start month in a chart based on the WTE data only. I can do this easily in excel.
My MS Excel example is below :
I want to show the percentage and the current WTE(Example below) :
Go to Solution.
Here are two examples in one app:
1. Using a calculated field in the script to create the WTE change % as a field in your data model.
2. Calculate the WTE change % on the fly in the chart using the Above() interrecord function.
Yes. It can be achieved by using the below expression.
see below an easy to create chart which comes close to your needs:
You have to use a Combo Chart with month as dimension and expression Sum(WTE) as bar chart. Expression Sum(WTE) / 1200.59 - 1 as line chart. Second axis is for %.
Hope this helps.