Create a field of existing field names

[hd1]

Hello, 

I have been trying to create a new variable that has a list of other field names loaded in QlikSense. 

is it possible to do so in QlikSense?

[kaushiknsolanki]

What are you trying to achieve with this?

[hd1]

I need to add filters to the dashboard from existing field names.

[kaushiknsolanki]

Apologies, but I am still not clear about what you want to do having all field names.

Can you help me understand with example.

[hd1]

sure..

I have data (attached in Excel) and i want to add a filter that shows..

VIP_1_year
VIP_5_year
VIP_10_year
Loyal_1_year
Loyal_5_year
regular_custmor
new_custmor

This will allow the user to filter data based on the field name

[kaushiknsolanki]

Hi,

You should create an inline table in script that will store the field names. For example.

Your normal Script will be.

Load 

VIP_1_year,
VIP_5_year,
VIP_10_year,
Loyal_1_year,
ID,
Loyal_5_year,
regular_custmor,
new_custmor

From xyz;

All you have to do is create an inline table as below.

FieldNames:

Load * inline [

FieldNames

VIP_1_year,
VIP_5_year,
VIP_10_year,
Loyal_1_year,
Loyal_5_year,
regular_custmor,
new_custmor

];

And use this field in your dashboard for end users to select the proper field.

[hd1]

I tried this solution however, the field values were static and upon clicking nothing happens to the other data. 

maybe its because i'm loading from multiple data sources? is there a mapping function in QlikSense that can create a this function from defined columns in excel?