Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

zhujason858_cha
New Contributor II

How to set variable to associated dimension value

For example I have two dimensions State and City. When I select or filter for San Francisco, I would like a variable to equal the associated dimension California (from the State field). My data structure works in such a way where based on the measure I need to create, California is not automatically associated and identified.

I feel like this can be done using the p() function or agg but I'm not sure how to?

Thanks so much!

Tags (2)
4 Replies
isingh30
Contributor III

Re: How to set variable to associated dimension value

Can you share your data or sample application?

Thanks.

zhujason858_cha
New Contributor II

Re: How to set variable to associated dimension value

I see the insert image, video, link options but no insert doc/app?

parthesh
Contributor

Re: How to set variable to associated dimension value

you will able to see only when you click on "Show full editor" option on top right of reply window. Smiley Happy

zhujason858_cha
New Contributor II

Re: How to set variable to associated dimension value

Hi please find my attached app, the relevant sheet is called: Heatmap: Stockout %. What I'm ideally trying to do is have it so that when you select a county or station in the Subcounty store table, the associated region is filtered for in the Regional Store table.

I think i could best do this by using a variable and p(), but please let me know if you have any other ideas. Thank you!

Community Browser