Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Using a function in a set expression, what am I missing?

Hi all,

I'm experiencing a peculiar problem. I have selected a single line in my dataset

Consider this expression in a textbox:

=Avg({$<Onderwerp={'REK-3F-CE'}>}Cijfer)

It shows 3.01, just what i expect.

Now what I was trying to do is give the sheet(s) a contextrich name, REK-3F-CE in this case.

=MID(GetActiveSheetId(),10)

This one shows REK-3F-CE, just what i expect.

Next step:

=MID(GetActiveSheetId(),10) = 'REK-3F-CE'

returns -1 (TRUE), just what i expect.

Next step:

=MID(GetActiveSheetId(),10) = Onderwerp

also returns -1

But the final step:

=Avg({$<Onderwerp={"=MID(GetActiveSheetId(),10)"}>}Cijfer)

This one does not yield the result i want, I'd like it to return the same 3.01 as the first expression.

I was under the impression the function is executed, and the result used in the compare, but I suppose I am missing something here.

Is there anyone who can enlighten me?

Kind regards,

Herb

1 Solution

Accepted Solutions
sunny_talwar

I think you missed the dollar sign expansion:

=Avg({$<Onderwerp={"$(=Mid(GetActiveSheetId(),10))"}>} Cijfer)

View solution in original post

4 Replies
sunny_talwar

I think you missed the dollar sign expansion:

=Avg({$<Onderwerp={"$(=Mid(GetActiveSheetId(),10))"}>} Cijfer)

Anonymous
Not applicable
Author

Thanks! Works like a charm!

Do you by any chance know a web-place where i can brush up on dollar sign expansion rules/examples etc?

Kind regards, Herb

sunny_talwar

You can check this link out:

The Magic of Dollar Expansions

Anonymous
Not applicable
Author

Thanks!