Discussion Board for collaboration related to QlikView App Development.
How to achieve Phase per episode ?
The data sample is below - where we can see one episode has 10 phase
So I used the expression : Sum(Measure_Phase)/Sum(Measure_Episode) to achieve that. Its working when only one Episode is selected.
By no selection is there: I am getting an output like below chart :
Is it taking the avg when no episode selection is done ?
below is the result when selecting only one episode:
What do you want it to do when no selection is made? Sum the value for each Episode?