Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

rcorcoran
Contributor

renaming dimension

HI

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()))


1 Solution

Accepted Solutions
MVP
MVP

Re: renaming dimension

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

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

5 Replies
MVP
MVP

Re: renaming dimension

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

Not applicable

Re: renaming dimension

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

MVP
MVP

Re: renaming dimension

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

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

Re: renaming dimension

Hi

Try like this

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

rcorcoran
Contributor

Re: renaming dimension

thanks tresesco that works great

Rhona

Community Browser