Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
george456
Creator
Creator

GetFieldSelections in Set Analysis

Hi Community

Can I ask a question regarding GetFieldselections in Set Analysis:

I have created an line load with possible selections( SDimensions)

 

=sum({<Type={'$(=GetFieldSelections(SDimensions))'},Month={<>}>}Units)/1000

How do I get the syntax to allow multiple selections because currently it will only allow one selection at a time.

 

This syntax is driving a bar graph output

2 Replies
george456
Creator
Creator
Author

 Dear Community

 

I have managed to solve this, can I share:

In my In Line load I have added 

load * Inline
[

SDimensions

"'Sales Achieved'",
"'JE Forecast'",

This allowed multiple selections 

 

Thanks

PrashantSangle

instead of getfieldSelection() you can try with concat()

like

=sum({<Type={$(=Concat(chr(39)&SDimensions&chr(39),chr(44)))},Month=>}Units)/1000

 

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂