topic Re: Alternate state in formula doesn't work in QlikView

Alternate state in formula doesn't work

chriscools — Wed, 17 Jun 2015 10:41:08 GMT

Hello,

I have a formula in which i want to incorporate alternate states.

if i use it like this it works:

but like this it doesn't work:

count ( {State2} {<OrderStatus={"On hold", "Placed" ,"Cancelled" , "Closed"}>} DISTINCT OrderNumber)

Any idea on how i need to fit it in to make it work?

thanx!!

Chris

swuehl — Wed, 17 Jun 2015 10:42:27 GMT

Try like this

count ( {State2<OrderStatus={"On hold", "Placed" ,"Cancelled" , "Closed"}>} DISTINCT OrderNumber)

vardhancse — Wed, 17 Jun 2015 10:43:04 GMT

count ( {State2} DISTINCT OrderNumber)

Wed, 17 Jun 2015 10:47:51 GMT

Hi Chirs,

You can use this code:

count ( {State2 < OrderStatus = {"On hold", "Placed" ,"Cancelled" , "Closed"} > } DISTINCT OrderNumber )

Ramya.

chriscools — Wed, 17 Jun 2015 10:49:43 GMT

Thank you, this works fine!!!

grtz,

chris