Data Selection Issue

[Anonymous]

Hi All,

Could someone please help me understand the behavior of Qlikview with the following selections. I have attached the "Whats new in QV 11" app to give you a testing copy of the issue i am facing.

In the attached QVW, i have made some selections like below.

Region		USA
Year		2010
Month		Aug
Quarter		Q3
Customer		C & C  Design

Now, when i select a different month apart from the months that belong to Q3, (Lets say i select "Jan" form the month filter) all of my other selection gets cleared off, though Data does exist for that selection also.

You can try this out on your own and please help me understand why this happens.

I am using QV 11.2 SR 6.

Thanks in advance,

Aadil

Message was edited by: Aadil M

[markodonovan]

Hi Aadil,

Does holding the CTRL key help ?

Mark

www.techstuffy.com

[Anonymous]

Hi Mark,

No it does not. The issue still exist.

Thanks,

Aadil

[markodonovan]

Sorry, I misread the problem.

I am only seeing this problem if the month selected is not associated with the other selections

Mark

[markodonovan]

Try selecting:

JAPAN, 2011, Q1

Then months Jan, Feb or Mar - should be ok

But Apr will clear the selections.

Thanks

Mark

www.techstuffy.com

[Anonymous]

Yes, Exactly, Any idea why it clears the selections, though the data or the key links do exist for the other selection also.

[alkesh_sharma]

Hello Adil,

This is the magic of associative nature of qlikview.

Q3 and August are associated (in WHITE), but Q3 and Jan (as you select Q3, JAN Greys Out) are not associated.

You can continue your can selection as far as you are selective Values that are associated, if you select a non associated value all previous selections will clear off and only your new selection will come into effect.

However you can put an restriction on selecting non-associative values.

[markodonovan]

Hi Aadil,

I wouldn't expect the selections to be cleared if the data exists for the combination of selections you are making.  That wouldn't make sense.

Mark

[markodonovan]

Hi Aadil,

For your selection Jan is not associated with the selected data only Jul\Aug\Sep:

[rubenmarin]

Hi Aadil,

When you select some 'grey' value others fields will be deselected, it's kind of normal that all other fields are deselected, there is when the use of locking selections is usefull, you can lock Region and Year to keep those values selected.