Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Certification Exam Sale - 40% off. Register by June 30, 2020. GET DETAILS
Highlighted
New 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
Highlighted
New Contributor III

Re: if else if in expressions

 

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
Highlighted
New Contributor III

Re: if else if in expressions

 

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