topic Re: Text Object - If Statement where Variable equals dimension in QlikView

Text Object - If Statement where Variable equals dimension

New2QlikView — Sat, 16 Nov 2024 02:17:30 GMT

I'm trying to create a text object with an if statement. I've created a variable called vDisplayLevel which relates to record numbers within a data set. I want certain fields to appear when the variable equals the corresponding record but I can't seem to get it to work.

Currently I'm using

=if(( vDisplayLevel = [Room]) , [Resident] , '')

and I've also tried

=if(( vDisplayLevel = [RoomNo]) , [Resident] , '') which converts the field [Room] to a text string. Neither of these seem to work and I can't seem to figure out what I'm doing wrong.

Any help would be greatly appreciated.

Re: Text Object - If Statement where Variable equals dimension

sunny_talwar — Mon, 07 Oct 2019 11:33:35 GMT

Are there multiple values for Resident that you expect to see? May be try one of these

=Concat(DISTINCT If(vDisplayLevel = [Room], [Resident], ''))

=Concat(DISTINCT If(vDisplayLevel = [RoomNo], [Resident], ''))

Re: Text Object - If Statement where Variable equals dimension

New2QlikView — Mon, 07 Oct 2019 11:37:53 GMT

Perfect, option 1 worked.