topic Re: How to set variable to associated dimension value in App Development

How to set variable to associated dimension value

Anonymous — Sun, 20 May 2018 11:37:07 GMT

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!

Re: How to set variable to associated dimension value

isingh30 — Sun, 20 May 2018 11:56:52 GMT

Can you share your data or sample application?

Thanks.

Re: How to set variable to associated dimension value

Anonymous — Sun, 20 May 2018 14:04:03 GMT

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

Re: How to set variable to associated dimension value

parthesh — Sun, 20 May 2018 15:09:23 GMT

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

Re: How to set variable to associated dimension value

Anonymous — Mon, 21 May 2018 09:30:22 GMT

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!