Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
deepakkrish
Contributor

Multiple If Condition

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:

Tablenullnot nullled 
Table 135green
Table221green
Table369Red

 

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.

3 Replies
Highlighted
zhadrakas
Valued Contributor II

Re: Multiple If Condition

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())))

Highlighted
Digital Support
Digital Support

Re: Multiple If Condition

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Highlighted
Surya
Contributor

Re: Multiple If Condition

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()))