topic Re: Expression using OR in QlikView

Expression using OR

Anonymous — Fri, 27 Jan 2017 12:42:14 GMT

Seems a simple question but can't find a discussion on it anywhere...How do I use OR in an expression.

I want to Express;

Sum({<

( [Site]={"Site1"},[Date]={"02/01/2017"},[Hour]={"13"} )

( [Site]={"Site2"},[Date]={"01/01/2017"},[Hour]={"14"} )

( [Site]={"Site3"},[Date]={"07/01/2017"},[Hour]={"16"} )

>} [Gross Sales])

This should produce;

Site	Date	Hour	Gross Sales
Site1	02/01/2017	13	£100,000
Site2	01/01/2017	14	£98,025
Site3	07/01/2017	16	£90,245

The Idea being that these are the top 3 results from another expression and I want only see results relating to them in combination only.

Many thanks for any help.

Re: Expression using OR

sunny_talwar — Fri, 27 Jan 2017 12:43:58 GMT

May be this:

Sum({<[Site] = {"Site1"}, [Date] = {"02/01/2017"}, [Hour] = {"13"}>+<[Site] = {"Site2"}, [Date] = {"01/01/2017"}, [Hour] = {"14"}>+<[Site] = {"Site3"}, [Date] = {"07/01/2017"}, [Hour] = {"16"}>} [Gross Sales])

Re: Expression using OR

tresB — Fri, 27 Jan 2017 12:45:20 GMT

OR is '+' in set analysis. Try like:

Sum({

<[Site]={"Site1"},[Date]={"02/01/2017"},[Hour]={"13"}>

<[Site]={"Site2"},[Date]={"01/01/2017"},[Hour]={"14"} >

<[Site]={"Site3"},[Date]={"07/01/2017"},[Hour]={"16"} >}

[Gross Sales])

Also note '< >'

Re: Expression using OR

Anonymous — Fri, 27 Jan 2017 13:13:43 GMT

That simple!

Thank you, couldn't find this anywhere.