topic SET ANALISYS in QlikView

SET ANALISYS

Fri, 14 May 2010 13:53:41 GMT

Hi all,

I have a problem with the set analisys expression. I would like, for example, to count all my items and the total should not change when selecting other fields except one field.

To get a total count I made:

Count ((1) TABLE1.ITEM)

If I write:

Count (() <YEAR> TABLE1.ITEM)

The count will never change if I select the YEAR field. But I would like to count only change by selecting the field YEAR.

Thanks, Capetto

SET ANALISYS

villafuerte — Fri, 14 May 2010 14:00:29 GMT

Hi Luca,

If you want a table to stay fixed you can use {1}, for example:

Count({1} Field)

If you want all the fields to stay fixed but you want also to change the year, yo can specify this in the Set Analysis as well:

count( {1 < Year={'2010'} >} Field)

You can use a selection or a variable instead of the 2010.

Hope it helps!

Re. :SET ANALISYS

martin59 — Fri, 14 May 2010 14:00:50 GMT

Hello,

You can try this :


Count ({1<Year=P(Year)>} TOTAL TABLE1.ITEM)

SET ANALISYS

villafuerte — Fri, 14 May 2010 14:12:53 GMT

Hello,

I made a simple example of this syntax. Maybe it can help you!

Re. :Re: SET ANALISYS

martin59 — Fri, 14 May 2010 14:18:39 GMT

Look at the attached file.

Martin

Re. :Re: SET ANALISYS

Fri, 14 May 2010 15:15:01 GMT

Thank you very much. It works fine 😉