Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

containing in expression

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

3 Replies
Not applicable
Author

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

or try this

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


Not applicable
Author

try this

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

Not applicable
Author

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

J.