Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Create a field of existing field names

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?

6 Replies
Highlighted
MVP & Luminary
MVP & Luminary

What are you trying to achieve with this?

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Contributor III
Contributor III

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

Highlighted
MVP & Luminary
MVP & Luminary

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

Can you help me understand with example.

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Contributor III
Contributor III

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

Highlighted
MVP & Luminary
MVP & Luminary

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.

 

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Contributor III
Contributor III

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?