Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
What are you trying to achieve with this?
I need to add filters to the dashboard from existing field names.
Apologies, but I am still not clear about what you want to do having all field names.
Can you help me understand with example.
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
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.
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?