topic Set analysis ? in QlikView

Set analysis ?

fabio_vallone — Mon, 11 Mar 2013 21:08:41 GMT

Hi,

I'm trying to create a table in QlikView, with some conditions: I have a QVD with several

events, each event from one client, like this:

Client Event Qtd

A 01 10

A 02 5

A 03 8

B 01 5

B 03 2

...

I want to compare the event number "01" with the other events:

Client Event (=01) Others (<>01) Others/Event#01

A 10 50 5,0

B 5 2 0,4

So, I tried to put Set Analysis like this:

= Sum( {$<Event={'01'}>} Qtd) , but doesn't work (because the Event "01" is not selected, just Event "04")

= Sum( {1<Event={'01'}>} Qtd) , but doesn't work too (in this case, all clients get "all" events #01- the same number for all clients)

How can I solve it ??

Thanks,

Fabio.

Re: Set analysis ?

CELAMBARASAN — Mon, 11 Mar 2013 21:20:52 GMT

Can you tell me what didn't work in this expression for you?.

Re: Set analysis ?

fabio_vallone — Tue, 12 Mar 2013 10:44:27 GMT

Each Event has a "Name" and a "Date". When I select some Name, the column "Event = 01" returns 0. (The Event 01 got out of scope of "$")...

Try to put in your example:

LOAD * Inline [

Date,Client,Event,Name, Qtd

'jan/2013',A,01,Event01,10

'fev/2013',A,01,Event01,10

'jan/2013',A,02,Event02, 5

'jan/2013',A,03,Event03, 8

'jan/2013',B,01,Event01, 5

'jan/2013',B,03,Event03, 2];

Then put a List of Names and Dates, and choose "Event 02", for example (the column "Event=01" returns 0). If I use "1" instead of "$", the column "Event=01" sum all Dates (wrong too).

Thanks again.

Fabio.

Re: Set analysis ?

Tue, 12 Mar 2013 11:05:38 GMT

Hello Fabio,

You can try using below in your First expression for Event 1:

=Sum({<Event={01}, Name=>}Qtd)

Let me know if this was helpful, or any thing else is required.

thanks,

itsangad

Re: Set analysis ?

fabio_vallone — Tue, 12 Mar 2013 11:13:59 GMT

Thanks itsangad. It works fine.

There are many variables in addition of "Name" and "Date". I need to put "all" in set analysis? There are some "generical" expression to consider any selection in other variables?

Thanks a lot.

Fabio.

Re: Set analysis ?

Tue, 12 Mar 2013 11:18:17 GMT

Hello Fabio,

As per my understanding, you need to put all variables which effect the change of the value of Qtd. Rest you can give it a try, surely someone else might give you a generic expression, if any.

thanks,

itsangad

Re: Set analysis ?

fabio_vallone — Tue, 12 Mar 2013 11:19:57 GMT

Great! Thanks again.

Fabio.

Re: Set analysis ?

Tue, 12 Mar 2013 13:52:36 GMT

Hello Fabio,

Came across this: here

Thanks,

itangad

Re: Set analysis ?

fabio_vallone — Tue, 12 Mar 2013 14:10:56 GMT

Excellent! It is exactly what I need.

Tks!