Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have to store value of field in variable from particular table. in general In Qlik sense, variable store values from globally whole sheet or app. I have a field say firstName which is used in several graphs in sheet. I want a variable to store FirstName from particular table only, It should not get update when i select FirstName from any another graph. Can we achieve this in qlik sense.
Any suggestion, please reply
Thanks,
As far as I know, you can't. You could work around this by loading FirstName as FirstNameForGraph and then using that in your specific chart, though. You could also consider using a separate State for this chart.
Hi,
You may be able to achieve what you want using Alternate State: define an alternate state for each table and try to populate your variable with an aggregation function using the Alternate State name. Something like:
max({AltStateName} firstName) (or a Concat)