topic Re: set analysis with a field > 0 in QlikView

set analysis with a field > 0

andyrebs — Wed, 14 Nov 2012 17:46:38 GMT

Hello ,

I am sorry for the very simple question I am doing, but, knowing how efficient you are, I will do it.

I want to create an expression with selection of the products that are in stock. I tryed with this expression below, but it is not correct.

sum({$<[Stock]>{0}>} Sales)

Thanks

Andrea

MayilVahanan — Wed, 14 Nov 2012 17:48:22 GMT

Sum({<Stock ={">0"}>}Sales)

Hope it helps

CELAMBARASAN — Wed, 14 Nov 2012 17:49:06 GMT

Hi,

You shoul use > , < inside the braces {}

sum({$<[Stock]={>0}>} Sales)

sum({$<[Stock]={">0"}>} Sales)

jagan — Thu, 15 Nov 2012 08:37:54 GMT

Hi,

Try this

=Sum({<Stock ={'>0'}>} Sales)

Regards,

jagan.

Thu, 15 Nov 2012 09:09:37 GMT

use this

sum({<stock={">0<=4"}>} sales)