Pass parameters to variable containing set expression

Anonymous — Tue, 23 Jan 2018 19:21:49 GMT

In Qlik Sense 3.2.2 I'm trying to dynamically generate a set expression in order to reduce repetitive coding in my app's sheets. I've seen some examples of this but only in a QlikView context.

Here is my set up:

Sheet variable vSheetId is defined as:

=MaxString({1<AppName={$1}>,SheetName={$2}}SheetId)

From another expression, I call this variable and pass the appropriate values for the App and Sheet IDs I want to look up:

=$(vSheetId('IRL', 'Overview'))

These values are in a data island table in my model. There are multiple combinations of these IDs that I need for different objects in my app.

I've tried several variations on this, but none have worked. If I simply hard code the set expression instead of using the $1 and $2 parameters, everything works. For example this works: =MaxString({1<AppName={IRL}>,SheetName={Overview}}SheetId)

Is what I'm trying to do even possible in QlikSense? If so, where am I wrong with my syntax, or is there an alternative way to do this?

Re: Pass parameters to variable containing set expression

sunny_talwar — Tue, 23 Jan 2018 20:03:14 GMT

Seems like you have a typo

=MaxString({1<AppName={$1}>,SheetName={$2}}SheetId)

=MaxString({1<AppName={$1},SheetName={$2}>}SheetId)

topic Re: Pass parameters to variable containing set expression in App Development

Pass parameters to variable containing set expression

Re: Pass parameters to variable containing set expression