Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.