Variables on a specific date using this in other dates in expressions not working
Not sure if this title surfices what i am trying to achieve.
ive been asked to replicate a spreadsheet so it can be live in Qlikview, which can show trajectories on reducing a waitlist and improving performance.
I have set up variables on a snapshot date -Mar19 which show targets, actual, and wl reduction required etc.
i have then tried to use this in a chart to show by month so current shapshot minus Wl reduction required (which is based on Mar-19 snapshot) but it only puts the calulcation in the month of mar19, not every month after - is that becuase im referencing March in the variable?
then in a chart i want to create a table that shows for each specialty the number of breaches each month actually, against the target each month which is
but becuase i have based all my variables on 1 snapshot (which i have to) , the target each month only works for that snapshot - it wont plot by month, i just need to take the wl reduction figure from the number of breaches each month
hope i have made sense. thanks for looking
i think i could easily quit on this, certain things you can do in excel better maybe.
Not sure if i understand you correctly , you are hardcoding for one month in your variable and want to calculate for each month . Removing the month filter and putting the calculation under a month dimension will make it calculate for each month . Its better you attach some sample file with test data explaining your scenario