Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikvw2019
Contributor
Contributor

if else if in expressions

I have 

column1 ,column2, column3

Below expression works fine : "If column1 & column2 are selected , then , else"

If(GetSelectedCount(column1)>=1 and GetSelectedCount(column2)>=1,MAX(PDB_SIZE),num(sum(DISTINCT(column2))/1024,'##.00'))

if i want to introduce more conditions  , please help with syntax

New condition: "If no columns selected, then"

 

 

 

 

 

1 Solution

Accepted Solutions
wandererroch
Contributor III
Contributor III

 

It would be

if(Some Comparison,Value if true,

       if(Another Comparison, Value if that's true,

              if(more comparisons,True again, The false value)

         )

  )

 

Basically the other expressions nest within each other in the section you hit when the condition isn't met.

View solution in original post

1 Reply
wandererroch
Contributor III
Contributor III

 

It would be

if(Some Comparison,Value if true,

       if(Another Comparison, Value if that's true,

              if(more comparisons,True again, The false value)

         )

  )

 

Basically the other expressions nest within each other in the section you hit when the condition isn't met.