Variable

[Rajesh31]

how to create a variable for the following in qliksense

when YTD_revenue <-100 then '-100'

when YTD_revenue =100 then '100'

when YTD_revenue>100 then '>100'

[Vegar · Accepted solution]

Try this

IF( YTD_revenue <-100, '-100', IF(YTD_revenue =100,'100', IF( YTD_revenue>100 , '>100')))

[Rajesh31]

Thank you so much @Vegar , It was helpful