Show Dimension/Field Name in QlikSense List Box

[lawrance]

Hi All,

How to show Field Name using list box in QlikSense.

Dimensions:

    1) ADR

     2)Total Guests

     3)Total Sold

Thanks,

Lawrance A

[OmarBenSalem]

ur question is not clear; that's why no one have answered u.

[lawrance]

Hi,

I want to show Field Name in the drop down list instead of showing Field Value.

For Example,

ADR	Total Guest	Total Sold
1	10	15
2	10	20
3	5	3

Drop Down List box contains

Measure
ADR
Total Guest
Total Sold

Thanks,

Lawrance A

[OmarBenSalem]

and what's the point?

u want to have this list that contains ur measure, and if u select one measure, u want ur chart's measure to be the one u select?

Is this ur final outcome?

[lawrance]

yes

[OmarBenSalem]

then create an inline table in ur script:

lod * inline [

Measure, MeasureID

ADR, 1

Total Guest,2

Total Sold,3

];

use this new Measure field as a selection List.

and in your charts, as a measure use:

if(MeasureID=1, sum(YourADRmeasure),

if(MeasureID=2, sum(YourTotalGuestMeasure),

sum(YourTotalSoldMeasure)))

with that, ur graphics will depend on the selection u made in ur new created Measure field