topic Re: Only negative expression in pivot table in QlikView

Only negative expression in pivot table

Wed, 09 Nov 2011 01:49:27 GMT

Hi, my English is not very good but I hope you can understand and help me.

I have a pivot table with multiple expressions that sum various data, one of the expressions acts as a total of the others expressions. What I do is only show rows

where this total is negative, Example:

Harvest	Species	Expression 1	Expresion 2	Expression 3	Expression (Total)
09/10	SOY	100	5	-90	15
09/10	CORN	100	-50	-90	-40
10/11	WHEAT	50	-20	-50	-20
10/11	CORN	80	-30	-10	40
11/12	SOY	80	-30	-50	0

What I need is that the table is as follows:

Harvest	Species	Expression 1	Expression 2	Expression 3	Expression (Total)
09/10	CORN	100	-50	-90	-40
10/11	WHEAT	50	-20	-50	-20

Any suggestions?

Thank you very much in advance. Greetings.

Luciano.-

Only negative expression in pivot table

Wed, 09 Nov 2011 05:58:54 GMT

Hi Luci,

I did not understand what you asked above, Can you explain me clearly.

Regards,

Antony.

Re: Only negative expression in pivot table

Wed, 09 Nov 2011 06:44:00 GMT

Hi Luciana,

Please find attached application as per your requirement.

Hope this is the one you asked.

Regards,

Antony.

Re: Only negative expression in pivot table

rohit214 — Wed, 09 Nov 2011 06:51:14 GMT

hi luci

use this expression in your pivot table

if(Expression (Total)<0,Expression (Total),0)

and in Proreties>> presentation>>Spress zero values

may it helps you

thanks

rohit

Only negative expression in pivot table

SunilChauhan — Wed, 09 Nov 2011 07:52:14 GMT

if(Expression (Total)<0,Expression (Total),0)

and presentation-Spress zero values

Re: Only negative expression in pivot table

Wed, 09 Nov 2011 11:57:28 GMT

Pardon for my bad English, that's exactly what I was looking for.

Thank you very much everyone.

Greetings from Argentina.

Luciano.-