topic Re: renaming dimension in QlikView

renaming dimension

rcorcoran — Tue, 03 Jun 2014 12:33:35 GMT

I have this expression below in a dimension of a straight table to limit the data it brings back. It works fine but I also want to rename the 3 and 5 to show bed days for Discharges=3 and inpatient for 5 in the chart. Any help??

thanks

=(if(Discharges='3' or Discharges='5',Discharges,Null()))

Re: renaming dimension

tresB — Tue, 03 Jun 2014 12:36:25 GMT

=If(Discharges=3, 'Bed Days', If(Discharges=5, 'Impatient' , Discharges))

Re: renaming dimension

Tue, 03 Jun 2014 12:38:44 GMT

Hi Rhona,

=if(Discharges='3' , Discharges,

if (Discharges='5', Inpatient,

Null()

) )

Here is what i understood

or may be you want to modify 3 and 5, you can use variables

best regards

Chris

Re: renaming dimension

tresB — Tue, 03 Jun 2014 12:41:35 GMT

I notice now, that you might not need other discharges, then :

=If(Discharges=3, 'Bed Days', If(Discharges=5, 'Impatient' , null()))

Re: renaming dimension

MayilVahanan — Tue, 03 Jun 2014 12:47:20 GMT

Try like this

Pick(Match(Discharges, 3, 5), 'Bed Days', 'Impatient')

Re: renaming dimension

rcorcoran — Tue, 03 Jun 2014 13:02:28 GMT

thanks tresesco that works great

Rhona