topic Re: Need help with "Or" Function in QlikView

Need help with "Or" Function

Thu, 20 Jun 2013 14:14:46 GMT

I have this formula below , where the value is not affected when I select a “National Account”

Sum({<[National Account] => } [QTYBACKORD])

I want to expand the formula and also include “Customer Group” , “Customer” and “Customer Code” . I’ve tried different formulas but with no success. Below is the last formula I tried.

Sum({<[National Account] => } [QTYBACKORD]) or

Sum({<[Customer Group] => } [QTYBACKORD]) or

Sum({<[Customer] => } [QTYBACKORD]) or

Sum({<[Customer Code] => } [QTYBACKORD])

Can you tell me where im going wrong.

kind regards

Nayan

Re: Need help with "Or" Function

jagan — Thu, 20 Jun 2013 14:24:43 GMT

Hi,

Try like this

Sum({<[National Account] => + <[Customer Group] => +
<[Customer] => +

<[National Account] => +
<[Customer Code] =>}
[QTYBACKORD])

Regards,

Jagan.

Re: Need help with "Or" Function

Thu, 20 Jun 2013 14:35:49 GMT

Hi Jagan

It works . Thank you

regards

Nayan