topic Re: Set analysis question in QlikView

Set analysis question

fredericvillemi — Thu, 19 Apr 2012 11:08:01 GMT

Hi,

i have a document with many dimensions : project, customer, dimension1, dimension2

i want to create a chart with an amount total which will be always the amount total for the selected "project" without looking at any other dimension.

I mean, i want to have the total only based on one filter, project

how can i do that with set analysis (or with another way) ?

Thanks

Re: Set analysis question

Thu, 19 Apr 2012 11:10:06 GMT

sum({1<Project=P()>} Field)

Re: Set analysis question

Thu, 19 Apr 2012 11:34:51 GMT

Hi Frederic,

I think this can be done by using the following expression :--

sum({<customer=,dimension1=,dimension2=,project=$(=only(project))>}field)

Re: Set analysis question

v_iyyappan — Thu, 19 Apr 2012 12:09:49 GMT

Hi,

use like this

= sum(TOTAL field)

Regards

Iyyappan

Set analysis question

fredericvillemi — Thu, 19 Apr 2012 12:51:40 GMT

Great, exactly what i wanted

and imagine i would like to add another dimension, how can i do it ?

only project and customer ?

Thanks

Re: Set analysis question

Thu, 19 Apr 2012 12:54:38 GMT

That is simple, just copy the syntax with a coma after to add more:

sum({1<Project=P(),customer=P()>} Field)