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

[Anonymous]

Hi Mark,

Sorry, if I am not explaining this clearly.

There is data available for " C & C Design" for Jan of 2010. But still the Jan selection clears off these selected values. Which is a little confusing.

Thanks,
Aadil

[markodonovan]

Hi Aadil,

It might be because I am on 11.2 SR8.

Can you take a screenshot of your selections and the months.

Thanks

Mark

[rubenmarin]

Hi Aadil, The selections in Quarter (Q3) are not compatible with month Jan

[renisonc]

I would understand that Q3 gets deselected when Jan is selected because of associative search. but why would the year or region get deselected. Jan is still a valid selection under those?

[NareshGuntur]

Hi All,

I think this should be the normal behavior of QlikView

Please go through the attached dashboard Movies Database(QlikView Model sheet).

I have applied the following selections:

Director: Akira Kurosawa

Title: Akahige

Actor: Akemi Negishi

Now, Akira Tani(Actor) is shown in Grey.

When I select Akira Tani, it only clears off the Title but the Director remains selected.

Can someone help me in understanding this?

Cheers,

Naresh

[alkesh_sharma]

If you go backwards, you will observe, when you select Akira Tani, it is not associated with Title-Akahige but associated with only one Director- Akira Kurosawa, That's why director remains selected.

[Anonymous]

Attached is a video of the scenario i am explaining in here. If you observer when i Select Jan, the other values gets cleared, but they do appear " in White" which means that they are associated with Jan selection, but just getting cleared for some reason.

[NareshGuntur]

Hi Alkesh

I tried with Actor 'Snub' Pollard who has multiple directors, and my initial selection (Director - Charles Chaplin) still remains

Cheers,

Naresh

[jpenuliar]

Hi,

In response to your selections and what happens when you select Jan.

With your current selection

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

Notice that the Month "Jan" is Grey,  this means that there is no data in the table with your current selections that have month January. So when you click Grey January, Qlikview will make  a new selection as your new selected field was not dessicated with your previous selection. i hope i got that right.

[jpenuliar]

Have a look at the Movies Database sample app and see "How Qlikview works" tab.