topic Re: Using If-else with AND and OR operators in QlikView

Using If-else with AND and OR operators

Sumit2504 — Tue, 30 Mar 2021 07:38:09 GMT

Hi All,

I want to create a reference line such that if user select Product A, B, C or combination of AB or BC or AC or ABC then it should display 10% in reference line.

Similarly, If product D, E or combination of DE should display 20%. Else 30%.

Can anyone please help me here.

Re: Using If-else with AND and OR operators

rwunderlich — Tue, 30 Mar 2021 22:00:17 GMT

if(Count({<Product={'A','B','C'}>}Product) > 0, .10
,if(Count({<Product={'D','E'}>}Product) > 0, .20
, .30))

-Rob

Re: Using If-else with AND and OR operators

Anil_Babu_Samineni — Wed, 31 Mar 2021 17:08:07 GMT

Also this

if(Match(Product, 'A','B','C') or Match(Product, 'AB') or Match(Product, 'BC') or Match(Product, 'AC') or Match(Product, 'ABC'), .10, if(Match(Product, 'D','E') or Match(Product, 'DE'), .20, .30))

Re: Using If-else with AND and OR operators

Heineman579 — Thu, 01 Apr 2021 09:01:52 GMT

@Sumit2504 wrote:
@Anil_Babu_Samineni @sunny_talwar
Hi All,
I want to create a reference line such that if user select Product A, B, C or combination of AB or BC or AC or ABC then it should display 10% in reference line.
Similarly, If product D, E or combination of DE should display 20%. Else 30%.
Can anyone please help me here.

The if/else statement is a logical, conditional expression that evaluates a condition and will only execute the block of code below it, if the condition is true. Please note that you have to use two characters as operator. Read more about JavaScript Operators