topic Re: containing in expression in QlikView

containing in expression

Wed, 24 Jul 2013 11:13:51 GMT

Hi,

i´m asking for an advice.

I have an expression :

Sum

({<acount={'0,1,2'},>}(NAKPRO.qty)) ....i know it´s wrong, i want to say: Calculate all items only of acount "0","1","2"....so there must be some function of containing these types of acount

Thx a lot:-)

Jaromir

Re: containing in expression

Wed, 24 Jul 2013 11:21:16 GMT

IF(acount=rowno(),NAKPRO.qty)

or try this

if(acount>=0 or acount <= 10,NAKPRO.qty)

Re: containing in expression

Wed, 24 Jul 2013 11:22:53 GMT

try this

if(match(acount,'0','1','2'),NAKPRO.qty)

Re: containing in expression

Wed, 24 Jul 2013 13:43:35 GMT

Thx guys,

your advices don´t work:-(

In fact, my formula is more complicated:

sum({<Year={$(=max(Year))},Week={"$(=max({<Year={$(=max(Year))}>}Week))"},Buyer={'Diana'},ItemSuplierCountry={'China'},Centre={'Prag,Viena,Boston'}>}(NAKPRO.qty))

The first part of formula defines the last one week of period for statistic, then some conditions and the last one is my request - possibility of limit concreete places of sale.

Please tell me where i should pleace a limited condition

Thx a lot