topic Re: Regarding association between two list boxes in QlikView

Regarding association between two list boxes

ak00428233 — Fri, 02 Mar 2018 18:00:26 GMT

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

Re: Regarding association between two list boxes

isingh30 — Fri, 02 Mar 2018 20:01:31 GMT

Please share your data or app.

Thank you!

Re: Regarding association between two list boxes

ak00428233 — Fri, 02 Mar 2018 20:15:00 GMT

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

Re: Regarding association between two list boxes

isingh30 — Fri, 02 Mar 2018 20:25:54 GMT

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

Thank youQ

Re: Regarding association between two list boxes

ak00428233 — Sat, 03 Mar 2018 07:54:23 GMT

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.

Re: Regarding association between two list boxes

ak00428233 — Sat, 03 Mar 2018 07:56:43 GMT

Data and qvw

Re: Regarding association between two list boxes

isingh30 — Sat, 03 Mar 2018 10:06:51 GMT

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

Thank you!

Re: Regarding association between two list boxes

ak00428233 — Sat, 03 Mar 2018 11:29:04 GMT

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