topic Set Analysis Issue in QlikView

Set Analysis Issue

Thu, 21 Aug 2014 11:49:06 GMT

Hi,

I have a set of sessions all with associated activities - some have timings (completed), some do not (to be completed).

I want to be able to select a number of uncompleted sessions, have them displayed in a table with their respective activity and projected average timings based on completed session timings.

The problem is that when I select an uncompleted session, it calculates an average based on the timings available for those sessions (i.e. all zero). If I set an expression to calculate timings ignoring session, it displays values for all sessions.

I though this expression would work, but it doesn't:

=avg(TOTAL <activity> {<session=>}time)

I'm sure there's a way to do this set analysis, but I'm struggling.

Can anyone suggest anything?

Thanks in advance.

Tom

Re: Set Analysis Issue

Gysbert_Wassenaar — Thu, 21 Aug 2014 12:29:24 GMT

I suggest you post an example document with some data.

Re: Re: Set Analysis Issue

Thu, 21 Aug 2014 14:58:04 GMT

Hi Gysbert,

I've attached a document with dummy data in the format I have mine - I'm trying to make it so that when you select session D or E in the projected table (complete_flag=0), you should get an average timing for each activity based on timings that actually exist (complete_flag=1).

Re: Re: Re: Set Analysis Issue

Gysbert_Wassenaar — Thu, 21 Aug 2014 15:23:10 GMT

See attached example for some suggestions. Possibly not what you actually want. Perhaps you can add a result table with the numbers you expect as results.