topic Re: Triggers Not Working on inline field in QlikView

Triggers Not Working on inline field

pradnyat — Wed, 17 Dec 2014 06:32:09 GMT

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.

prakashpawar

Re: Triggers Not Working on inline field

pradnyat — Wed, 17 Dec 2014 07:10:56 GMT

Any solution to resolve this issue??

Re: Triggers Not Working on inline field

saumyashah90 — Wed, 17 Dec 2014 07:13:32 GMT

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

Re: Triggers Not Working on inline field

pradnyat — Wed, 17 Dec 2014 07:21:01 GMT

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?

Re: Triggers Not Working on inline field

saumyashah90 — Wed, 17 Dec 2014 07:26:46 GMT

Trigger does work...can you tell me more about your requirement

Re: Triggers Not Working on inline field

pradnyat — Wed, 17 Dec 2014 07:38:10 GMT

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.

Re: Triggers Not Working on inline field

saumyashah90 — Wed, 17 Dec 2014 07:55:04 GMT

Got your point.

This is against QlikView because of associative nature.

Will have to use Alternative States which make this very complicated

Re: Triggers Not Working on inline field

saumyashah90 — Wed, 17 Dec 2014 08:04:59 GMT

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

Re: Triggers Not Working on inline field

pradnyat — Wed, 17 Dec 2014 08:06:01 GMT

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.

Re: Triggers Not Working on inline field

saumyashah90 — Wed, 17 Dec 2014 08:10:18 GMT

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.

Re: Triggers Not Working on inline field

pradnyat — Wed, 17 Dec 2014 13:49:15 GMT

Is there any other workaround for this issue??

Re: Triggers Not Working on inline field

saumyashah90 — Wed, 17 Dec 2014 13:53:01 GMT

As i said earlier.

This could be the workaround:

Load all these field as different table:

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;

Re: Triggers Not Working on inline field

pradnyat — Wed, 17 Dec 2014 13:57:44 GMT

From back end we are getting all the things in 1 one table and we can't load it from separate tables as there are other fields also which we need from same table.

Re: Triggers Not Working on inline field

saumyashah90 — Wed, 17 Dec 2014 14:07:50 GMT

You can break down the table once loaded:

Forexample you have:

Table:

Load

Franchise_Territory_Number,

Geography_Code,

Territory_Number

From xyz;

Load all three fields as different tables like:

Table1:

load

Franchise_Territory_Number

Resident Table;

Table2:

Load

Geography_Code

resident Table;

Table3:

Load

Territory_Number

resident Table;

Drop table Table;

Re: Triggers Not Working on inline field

saumyashah90 — Wed, 17 Dec 2014 14:24:16 GMT

Are you able to do it?

Re: Triggers Not Working on inline field

Tue, 30 Dec 2014 13:49:56 GMT

Hi Pradnya,

PFA,

Hope this will solve your problem.