topic Re: Re: Re: Set-analisys in pivot table in QlikView

Set-analisys in pivot table

Anonymous — Mon, 30 Sep 2013 10:42:33 GMT

Hallo!

In the attached example I'd like to show the rows of the pivot table only if the sum of the credits for a single customer is greather than its thresold: can someone help me to set the set_analisys formula?

Yhank you very much.

Re: Set-analisys in pivot table

swuehl — Mon, 30 Sep 2013 12:12:42 GMT

Try something like

if(Sum(Credit)>Threshold,sum(Credit))

Re: Re: Set-analisys in pivot table

Anonymous — Mon, 30 Sep 2013 12:50:45 GMT

Well, you're right...the sample I gave is an extraction of my table which contains more fields in the expressions, so I think have to set the condition in the dimension field with the set_analysis. I apologize if I didn't post the correct example the first time.

Now I attached it.

Thank you.

Re: Re: Re: Set-analisys in pivot table

swuehl — Mon, 30 Sep 2013 13:07:54 GMT

You can try like attached, checking in all your expressions if the sum(Credits) is applicable, e.g. in first expression of your sample

=if(column(2), sum(Invoice))

Re: Re: Re: Set-analisys in pivot table

Anonymous — Mon, 30 Sep 2013 13:31:24 GMT

Very good!! Thank you very much.