Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a small doubt regarding association between two list boxes.
If we consider some regions like north America,South America,Africa,Australia,Africa and Europe.
Due to some reasons the data of other regions are visible even though there is association between regions and countries.
Could you please suggest me an expression such that when I select particular region I want to see the data of a particular region only.The other regions data need to be restricted anyhow.
Thanks in advance.
Regards,
Anu
Please share your data or app.
Thank you!
Hi Ishtdeep,
Data:
Load* Inline[
Region Countries
Asia China,Singapore,Pakistan,
Africa Egypt,Lebanon
];
There was some information generated for different countries. But some analysts of Africa have checked the data of Asia also.
The issue happening here is when I select
Africa I am able to see the data of asia also.(as the analysts of the Africa is checking asia data.). Data is showing correctly as per functionality.
But I want to restrict the data in list box such that when I select Africa I want to see only the data of the countries in Africa.
Could you please suggest me that conditional expression.
Thanks in advance.
Regards,
Anu
Need to check your data & the restriction part. Can you share your raw sheet or app?
Thank youQ
Hi Ishtdeep,
Please find the attached qvw.
Screenshot:
In the screenshot i have selected andrew who is from north america but as he accessed south america reports we are able to see south america and north america report in data.
So kindly please help me to get the data according to the region which user belongs or the data according to the region.
Data and qvw
Why we have region's name in data accessed? It's not making sense to me.
Thank you!
Yeah the data accessed from source path(accesspoint) is with country name.Sorry in this mock up i have concatenated with region .