topic Re: Variable in QlikView

Variable

Rajesh31 — Thu, 01 Dec 2022 15:56:05 GMT

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 — Thu, 01 Dec 2022 16:43:49 GMT

Try this

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

Rajesh31 — Wed, 07 Dec 2022 09:25:36 GMT

Thank you so much @Vegar , It was helpful