topic Re: Multiple If Condition in QlikView

Multiple If Condition

deepakkrish — Sat, 16 Nov 2024 19:50:43 GMT

Hello All,

I have one table it has 4 columns , first column has all the table names second one is null values and third column is not null values. I want to display led gauge based on some condition . see below is my table ..

Table:

Table	null	not null	led
Table 1	3	5	green
Table2	2	1	green
Table3	6	9	Red

condition for led :

if($Table='Table1', count(Table1.Name)>=2 and wildmatch(Table1.address,'Delhi','bangalore'),green(),

if($Table='Table2' , count(Table2.Name)>=5 and match(Table2.Pin,'123','456'),green(),red())))

how to write multiple if condition to show color for LED column? Give me your ideas ,solutions .

Thanks in advance.

Krish.

Re: Multiple If Condition

zhadrakas — Mon, 28 Oct 2019 13:31:09 GMT

maybe this:

if($Table='Table1' AND count(Table1.Name)>=2 and wildmatch(Table1.address,'Delhi','bangalore'),green(),

if($Table='Table2' AND count(Table2.Name)>=5 and match(Table2.Pin,'123','456'),green()

,red())))

Re: Multiple If Condition

Brett_Bleess — Wed, 30 Oct 2019 21:07:48 GMT

Deepak, did Tim's post help you get things working as you wished? If so, be sure to come back and use the Accept as Solution button on his post to give him credit and let others know that did work. If you are still working on things, please leave an update for us.

Regards,
Brett

Re: Multiple If Condition

Surya — Thu, 31 Oct 2019 09:39:13 GMT

Hello., Try This

if(wildmatch(Table,'Table1'),count(Name) >= 2 and wildmatch(Address,'Delhi','banglore'),Green(),

if(wildmatch(Table,'Table2'),count(Name) >=5 and wildmatch(Pin,'123','456'),Red()))