topic Retain Product Selection Why Not? in QlikView

Retain Product Selection Why Not?

Thu, 26 Apr 2012 19:06:19 GMT

So he is the thing i have 3 tables as in load script below.

Now I select product A.

Select Terr D123

Select StoreID 1

Now when I change my selection to

Select Terr D234

My StoreID gets cleared. Agreed since Store ID 1 does not exist this territory

Why Does my Product A selection clear too? This very well existsin the new Territory.

Can I not retain this product selection.

Client requirement:

Select n products from 100 products. Drill Selection to a territory.

look for value of a store( from 50 stores)

change selection to a different territory for the same products

select new store

for sum(Qty) of the n products which had been selected only

Load Script:

LOAD * INLINE [

STOREID, Product, QTY

1, A, 2

1, B, 3

1, C, 4

2, A, 5

2, B, 6

2, C, 7

3, A, 8

3, B, 9

3, C, 10

];

LOAD * INLINE [

STOREID, ZIP

1, 012

2, 022

3, 032

];

LOAD * INLINE [

ZIP, Terr, Dis

012, D123, D1

022, D234, D2

032, D345, D3

];

Retain Product Selection Why Not?

mphekin12 — Thu, 26 Apr 2012 19:22:37 GMT

When you select a new territory (D234), your Product list box get cleared because all three products are associated with the new territory you selected. If you want to retain your selection of Product 'A' lock it by either right clicking on the list box and clicking 'Lock' or click the 'Lock' icon on the toolbar. I hope this helps!

Retain Product Selection Why Not?

Thu, 26 Apr 2012 19:37:02 GMT

Okay so if that is the case then

From what I understand here is if i deselect the store and then change the territory my product selection retains though the new territory has all 3 products associated with it. Why does it not lose its state then?

Think about it.

I need to retain this filter and i cannot use lock and unlock as my client does not like it.

How about clearing the store ID's if any selected before changing the district. How do i do that using triggers or macros?

Retain Product Selection Why Not?

Thu, 26 Apr 2012 19:38:26 GMT

FYI... the product filters is displayed in LED checkboxes with no caption header on the client's ipad on safari. Hence the no right click and locking... Please understand

Re: Retain Product Selection Why Not?

mphekin12 — Thu, 26 Apr 2012 20:21:20 GMT

Will something like the attached file work? It uses triggers to lock the Product list box. Each time the Product list box is activated it gets unlocked. When it is deactivated it gets locked. I couldn't get the Store ID to clear when changing Territories.

Retain Product Selection Why Not?

Fri, 27 Apr 2012 05:41:26 GMT

Hey i think you are using QV 10 if i am not wrong. Object based triggers have been removed from QlikView 11.

Probably that is why your example does not work for me. The field triggers fire after the selection or change is made. Only if i could make them fire before the Territory selection takes place.

Any one with any other suggestion?