Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ak00428233
Contributor III
Contributor III

Regarding association between two list boxes

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

7 Replies
isingh30
Specialist
Specialist

Please share your data or app.

Thank you!

ak00428233
Contributor III
Contributor III
Author

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

isingh30
Specialist
Specialist

Need to check your data & the restriction part. Can you share your raw sheet or app?

Thank youQ

ak00428233
Contributor III
Contributor III
Author

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.

ak00428233
Contributor III
Contributor III
Author

Data and qvw

isingh30
Specialist
Specialist

Why we have region's name in data accessed? It's not making sense to me.

Thank you!

ak00428233
Contributor III
Contributor III
Author

Yeah the data accessed from source path(accesspoint)  is with country name.Sorry in this mock up i have concatenated with region .