Solved: How to user If ..Then..elseIF to create a column - Qlik Community

vijaysahu2 · ‎2018-09-17

Hi All

Can we use this if then elseif to create a column name my script?

IF a>0 then

'Current value

ELSEIF a<0 THEN

'Previous Value'

ELSE

'None'

END IF AS MyColumnName

Or

Do we have any alternative to do this comparison and form a column.?

Thanks

Vijay Sahu

Anil_Babu_Samineni · ‎2018-09-17

Try this way?

IF(a>0, 'Current value', IF(a<0, 'Previous Value, 'None'))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

Anil_Babu_Samineni · ‎2018-09-17

Try this way?

IF(a>0, 'Current value', IF(a<0, 'Previous Value, 'None'))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

vijaysahu2 · ‎2018-09-17

Thanks anil..this helped me..