Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
siddharthsoam
Partner - Creator II
Partner - Creator II

Can we use getfieldselection function in load editor of qliksense

Hi I want to use getfieldselections() function for fetching value of my quarter from filter in data load editor. Is it possible in Qliksense?

8 Replies
mdmukramali
Specialist III
Specialist III

Hi,

afaik i don't think you can use getfieldselection() in the backend.

but what are trying to achieve let us know.

we will try to help you .

if possible share sample

shraddha_g
Partner - Master III
Partner - Master III

Store front end selections in Variableby using Concat(GetFieldSelection(Fieldname),',').

And use that variable in backend

siddharthsoam
Partner - Creator II
Partner - Creator II
Author

Hi Shraddha,

Thanks for coming in, I have created a variable. can you tell me how to use it inside my load editor when I want to use inside a column.

shraddha_g
Partner - Master III
Partner - Master III

what is the script?

siddharthsoam
Partner - Creator II
Partner - Creator II
Author

My variable description is Concat(GetFieldSelections(Quarter),',') and name is q_selection

I want to make a column using it i.e. quarter-1 as previousquarter.

shraddha_g
Partner - Master III
Partner - Master III

then again previous quarter calculation you can do at front end and then use that in concat().

For quarter field create Previous Quarter Field in Backend.

and for quarters selection you can use Concat( {<QuarterField = p(QuarterField)>} PreviousQuarterField,',')

siddharthsoam
Partner - Creator II
Partner - Creator II
Author

So basically we can do manipulations based on filter selections in front end only

shraddha_g
Partner - Master III
Partner - Master III

You can manipulate in Backend also if you are selecting only one value in frontend