Discussion Board for collaboration on QlikView Scripting.
I'm experiencing a peculiar problem. I have selected a single line in my dataset
Consider this expression in a textbox:
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.
This one shows REK-3F-CE, just what i expect.
=MID(GetActiveSheetId(),10) = 'REK-3F-CE'
returns -1 (TRUE), just what i expect.
=MID(GetActiveSheetId(),10) = Onderwerp
also returns -1
But the final step:
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?
Go to Solution.
I think you missed the dollar sign expansion:
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
You can check this link out:
The Magic of Dollar Expansions