topic Re: Logical OR Selections in QlikView

Logical OR Selections

haymarketpaul — Tue, 16 Jun 2015 13:20:04 GMT

I have a tablebox of data and a multibox of various regional areas (Country, Town, County, Postcode)

The user has a requirement to be able to select for example users in Manchester or within the TW postcode range.

If they select Manchester and then select teh TW postcode range it unselects Manchester and vice versa

Is there a certain way of going about allowing this sort of selecting?

I know the user could use the Advanced Search on an ID column and then use Wildmatch within that but it's not very user friendly.

Any pointers much appreciated

Re: Logical OR Selections

giakoum — Tue, 16 Jun 2015 13:28:18 GMT

So what you are saying is that you want to select Manchester and post codes that do not belong to Manchester? One way would be o select Manchester, select all postcodes that correspond to Manchester and then keep selecting postcodes with Cntrl pressed so that even more postcodes are added to the selection.

This will unselect Manchester, but you do not care as its postcodes are selected

Re: Logical OR Selections

prashantbaste — Tue, 16 Jun 2015 13:30:59 GMT

Hi Paul

In this scenario it seems that user is selecting data which is not related; what I mean is when user selects country and then next Postcode there might be postcode which does not belongs to selected country, that's why earlier selection gets removed.

Qlikview has very good feature of associativity, which indicates/highlights associated fields of selection.

In your case, once user selects Country, it will show postcodes activated which belongs to selected country, rest of postcodes will be colored as 'Gray' which means they are inactive for current selections.

Give a clear idea of how this works to user.

I hope this will be helpful for you.

Re: Logical OR Selections

richard_pearce6 — Tue, 16 Jun 2015 13:34:49 GMT

My blog Selections and Logical Inference | qlikcentral talks through how associations are made in QlikView when a user makes selections.

Richard

Re: Logical OR Selections

awhitfield — Tue, 16 Jun 2015 13:35:22 GMT

Hi Paul,

any chance you can upload your qvw as I'm sat in M15?

Andy

Re: Logical OR Selections

Gabriel — Tue, 16 Jun 2015 13:46:27 GMT

Hi,

By nature QlikView will associate where possible and as mentioned above 1 selection will give us green, gray and white.

If users requirement is to be able to make PostCode (gray) selection outside of the associate logic of QlikView then I will suggest break the associative of both tables. i.e. having 1 of the table as Island.

And if they are coming from same table move one of the field out into a new table and have it as Island.

Re: Logical OR Selections

haymarketpaul — Tue, 16 Jun 2015 14:28:18 GMT

Thanks for replies all.

Yes Ioannis has got the idea.

So what you are saying is that you want to select Manchester and post codes that do not belong to Manchester?

Currently i've got all the regional fields in one table so perhaps as Gabriel suggests separating them out might help.

We're constantly asked for these sort of data pots based on a combination of 'odd' regional selections.

It's GP data so hard to post an example i'm afraid.

Re: Logical OR Selections

giakoum — Tue, 16 Jun 2015 14:31:07 GMT

I guess what they want to see is fixed, so you could maybe create bookmarks based on postcodes

Re: Logical OR Selections

haymarketpaul — Tue, 16 Jun 2015 14:39:19 GMT

Would be nice but i fear there are too many weird and whacky scenarios - they can get quite specific sometimes.

Re: Logical OR Selections

swuehl — Tue, 16 Jun 2015 14:50:22 GMT

Maybe like attached?

Re: Logical OR Selections

haymarketpaul — Tue, 16 Jun 2015 15:05:27 GMT

That looks interesting - thank you

I'll have a play and see what i can do

Re: Logical OR Selections

haymarketpaul — Wed, 17 Jun 2015 11:51:19 GMT

Thanks - looks interesting - have signed up