Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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.