topic Re: If wih multiples conditions in QlikView

If wih multiples conditions

Zaga_69 — Sat, 16 Nov 2024 04:46:27 GMT

Hi dear all,

I ma trying to fix the following condition for a reference line a Bar chart.

=if(Company='HMG' and [Creation Year]='2018',0.5,0)

However it does not work.

Any idea?

Thanks!

Edi

Re: If wih multiples conditions

Zaga_69 — Sun, 13 Jan 2019 13:52:32 GMT

Hi all,

I tried the following code line and works:

IF(Company='HMG' and [Creation Year]=2018 , 0.59,0)

However what I would like to do is creating two references lines when users select Company and Creation Year. I realized that I can create multiple Reference Lines by just adding a new reference line "Add reference Line".

IF(Company='HMG' and [Creation Year]=2018 , 0.68,0)

In my case it is not a solution because when the user select another company , I will have the another reference lines as well.

What I need is to add two reference lines depending on the Company and Creation Year.

Any Idea?

Many Thanks!

Edi

Re: If wih multiples conditions

marcus_sommer — Sun, 13 Jan 2019 14:57:53 GMT

I think you could just nest your conditions like:

if(company = 'a' and year = 2018, x,
if(company = 'b' and year = 2018, y, z))

and you might also include a further check if the companies are external/internal, with getselectedcount() the number of selected values and many more, whereby by a larger number of conditions it might be easier to add these data within the datamodel instead of using very deep if-constructs.

- Marcus

Re: If wih multiples conditions

Zaga_69 — Mon, 14 Jan 2019 14:53:54 GMT

Hi Marcurs!

Thank you.

What I have done was to build two Line References following your code:

External

if(Company ='HMH' and [Creation Year]=2018, 0.14,
if(Company ='HMG' and [Creation Year]=2018, 0.59,
if(Company ='HMN' and [Creation Year]=2018, 0.14,0)))

Internal

if(Company ='HMH' and [Creation Year]=2018, 0.68,
if(Company ='HMG' and [Creation Year]=2018, 0.35,
if(Company ='HMN' and [Creation Year]=2018, 0.24,0)))

In that way I have both references lines. it was the easier solution 🙂

I did get your idea with getselectedcount() 😕

Best regards!

Edi