Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
ashmitp869
Creator
Creator

Assistance required to achieve the result in expression

Hi ,

How to achieve Phase per episode ?

The data sample is below - where we can see one episode has 10 phase

ashmitp869_0-1623383478189.png

 

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 ?

1.PNG

below is the result when selecting only one episode:

sel.PNG

 

1 Reply
sunny_talwar

What do you want it to do when no selection is made? Sum the value for each Episode?