Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

ak00428233
New 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

Tags (1)
7 Replies
isingh30
Valued Contributor

Re: Regarding association between two list boxes

Please share your data or app.

Thank you!

ak00428233
New Contributor III

Re: Regarding association between two list boxes

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
Valued Contributor

Re: Regarding association between two list boxes

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

Thank youQ

ak00428233
New Contributor III

Re: Regarding association between two list boxes

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
New Contributor III

Re: Regarding association between two list boxes

Data and qvw

isingh30
Valued Contributor

Re: Regarding association between two list boxes

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

Thank you!

ak00428233
New Contributor III

Re: Regarding association between two list boxes

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