Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

JustinDallas
Valued Contributor

Get 'or' into Gauge Expression

Hello Everyone,

I've got a Gauge, and I need to have an 'Or' statement evaluated.  But for the life of me I can't figure out how to do it.  My statement looks like so, and it errors out no matter what:

(

   COUNT({<isDelivery={'1'},

    OutofGracePeriod={'1'},

    ([Destination Point] = {'Miami'} or [Origin Point] = {'Charlotte'} )

    >}

  [Flight Number]

)

Any help on this rookie issue would be greatly appreciated.

3 Replies
MVP
MVP

Re: Get 'or' into Gauge Expression

Try this

Count({<isDelivery={'1'}, OutofGracePeriod={'1'}, [Destination Point] = {'Miami'}>+<isDelivery={'1'}, OutofGracePeriod={'1'}, [Origin Point] = {'Charlotte'}>} [Flight Number])

MVP
MVP

Re: Get 'or' into Gauge Expression

or not sure, but try this as well

Count({<isDelivery={'1'}, OutofGracePeriod={'1'}>*(<[Destination Point] = {'Miami'}>+<[Origin Point] = {'Charlotte'}>)} [Flight Number])

atkinsow
Valued Contributor II

Re: Get 'or' into Gauge Expression

Or maybe?

Count({<isDelivery={'1'}, OutofGracePeriod={'1'}, [Destination Point] = {'Miami'}>[Flight Number]) +

Count({<isDelivery={'1'}, OutofGracePeriod={'1'}, [Destination Point] = {'Charlotte'}>[Flight Number])