Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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'
Try this
IF( YTD_revenue <-100, '-100', IF(YTD_revenue =100,'100', IF( YTD_revenue>100 , '>100')))
Try this
IF( YTD_revenue <-100, '-100', IF(YTD_revenue =100,'100', IF( YTD_revenue>100 , '>100')))
Thank you so much @Vegar , It was helpful