topic Re: How to use multiple conditions? in QlikView

How to use multiple conditions?

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I want to write a statement like below but it doesn't work.

count({<[visit state]={"yes"} , [order state]={0} or [state number]>=130511>} terminal )

In another word, I want to count terminals that visited and they have order to visit, or they have state number bigger than 130511.

I wonder if you could help me?

Re: How to use multiple conditions?

tresB — Thu, 09 Mar 2017 08:17:27 GMT

May be like:

count({<[visit state]={"yes"} > * (< [order state]={0}>+< [state number]={'>=130511'}>)} terminal )

count({<[visit state]={"yes"} , [order state]={0}>+<[visit state]={"yes"} , [state number]={'>=130511'}>} terminal )

Edit: corrected a brace in the second solution.

Re: How to use multiple conditions?

ahaahaaha — Thu, 09 Mar 2017 08:19:05 GMT

Hi,

Maybe something like this?

count({<[visit state]={'yes'}, [order state]={'0'}, [state number]={">=130511"}>} terminal )

Regards,

Andrey

Re: How to use multiple conditions?

Thu, 09 Mar 2017 08:25:00 GMT

Thank you in advance but unfortunately any of them didn't work.

Re: How to use multiple conditions?

Thu, 09 Mar 2017 08:26:45 GMT

Dear Andrey,

Thank you for your comment. But it didn't work.

In addition I think I should use or function. But I have problem with the function.

Re: How to use multiple conditions?

adamdavi3s — Thu, 09 Mar 2017 08:29:07 GMT

count({<[visit state]={"yes"} , [order state]!={0},[state number]={">=130511"}>} terminal ) + count({<[visit state]={"yes"} , [order state]={0},[state number]={"<130511"}>} terminal )

Re: How to use multiple conditions?

Thu, 09 Mar 2017 08:45:09 GMT

Hi,

I think Treseco B second solution is ok but there was mistake in parenthesis. The correct one is below:

count({$<[visit state]={"yes"} , [order state]={0}>+<[visit state]={"yes"} , [state number]={'>=130511'}>} terminal )

BR,

Milosz

Re: How to use multiple conditions?

sasiparupudi1 — Thu, 09 Mar 2017 09:03:31 GMT

=count({<[visit state]={"yes"}>+<[order state]={0}>+<[state number]={'>=130511'}>

} terminal )

Re: How to use multiple conditions?

HirisH_V7 — Thu, 09 Mar 2017 09:11:48 GMT

you can write like this,

If([order state]='0' and  [state number]>=130511, 


count({<[visit state]={"yes"}>} terminal ))


OR

If([order state]='0' or [state number]>=130511, 




count({<[visit state]={"yes"}>} terminal ))

HTH,

Hirish