Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

lawrance
Contributor II

Show Dimension/Field Name in QlikSense List Box

Hi All,

How to show Field Name using list box in QlikSense.

Dimensions:

    1) ADR

     2)Total Guests

     3)Total Sold

Thanks,

Lawrance A

5 Replies
OmarBenSalem
Esteemed Contributor

Re: Show Dimension/Field Name in QlikSense List Box

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

lawrance
Contributor II

Re: Show Dimension/Field Name in QlikSense List Box

Hi,

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

For Example,

ADRTotal GuestTotal Sold
11015
21020
353

Drop Down List box contains

Measure
ADR
Total Guest
Total Sold

Thanks,

Lawrance A

OmarBenSalem
Esteemed Contributor

Re: Show Dimension/Field Name in QlikSense List Box

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
Contributor II

Re: Show Dimension/Field Name in QlikSense List Box

yes

OmarBenSalem
Esteemed Contributor

Re: Show Dimension/Field Name in QlikSense List Box

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

Community Browser