Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
];
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!
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?
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
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.
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?