Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
We are facing one issue while writing the triggers. We have loaded 1 inline table Geography with 4 values:
State, Franchise, Territory, HCR.
We have 4 different fields for the same which are coming from back end.
The intended functionality is, when we are selecting inline Geography with any value all the other 3 selections should be cleared and minstring of selected geography should be selected, this will work fine when we have the associated values.
But e.g. in case where we have selected any State for which no Franchise is associated and then we are selecting Geography as Franchise then minstring trigger is not working.
We are using field event triggers on inline field Geography.
Please find the attached sample document.
Any solution to resolve this issue??
Fields loaded in Hidden Script or under Directory should match with the fields loaded with Inline Table i.e Geography.
Once that is done it should work fine
Hi Saumya,
Thanks for your quick response.
Geography field which we are loading as inline is just for visualization purpose. User wants this field to switch between different geography types.
Depending on this selections we are activating the other list boxes. We can't directly use the back end field because it will restrict the data in all tabs and we don't want this sort of functionality.
Is there any way to solve this with inline field?
Trigger does work...can you tell me more about your requirement
Do u get a chance to look at the sample attached document??
Requirement is:
There is 1 inline field Geography.
If we select Franchise from Geography field, the min string of Franchise_Territory_Number should be selected and all the other 2 fields(Geography_Code and Territory_Number) should be cleared.
Now when user switches to State in Geography field, Franchise_Territory_Number and Territory_Number should be cleared and min string of Geography_code is selected.
Got your point.
This is against QlikView because of associative nature.
Will have to use Alternative States which make this very complicated
And also you have one more workaround to it:
All three fields i.e Franchise_Territory_Number
Geography_Code
and
Territory_Number
Load all three fields as different tables like:
load
Franchise_Territory_Number
from abc;
Load
Geography_Code
from xyz;
Load
Territory_Number
from pqr;
and continue with your approach.It will work
Can u please explain in what manner its breaking qlikview associative nature because while switching between Geography inline values we are first writing trigger to clear the selected values and then we are writing trigger to select min string value.
So when selected values will be cleared all the other values will be associated.
As said:
if you click on "Franchise" only minstring of "Franchise_Territory_Number" gets selected and all values associated to that selection in Geography code and territory number should get cleared. this is against the associative nature.