topic Re: Trigger not working in QlikView

Trigger not working

dandaanilreddy — Wed, 25 Nov 2020 16:16:04 GMT

Hello Qlik Developers

In my application for a sheet i wrote trigger select in field and i gave the value for the field. By default i am displaying always one selected value as 1 month. if i go to another sheet and come back to the sheet where i have applied the trigger the list box is showing 1 month selected value as default but the charts are not displaying the data for 1 month. If i selected 3 month option in list box and come back to 1 month selection the data is displaying in the chart. Can someone help me please

Thanks

Anil

Re: Trigger not working

hemanthaanichet — Wed, 09 Nov 2016 04:43:59 GMT

Hi Anil,

I had done something using trigger which might be helpful to you

Attachment is there for your reference

if u can provide sample data which will be more helpful. so that i can know what your exact issue

Regards

Hemanth

Re: Trigger not working

tresB — Wed, 09 Nov 2016 04:48:50 GMT

Probably someone can help if you can provide your qvw with sample data that demonstrates the issue.

Re: Trigger not working

Anonymous — Wed, 09 Nov 2016 08:36:34 GMT

Hi ,

Can you share related document .

Re: Trigger not working

Anil_Babu_Samineni — Wed, 09 Nov 2016 08:59:31 GMT

You can say, You want to clear triggers from Curr to Prev sheet. You should write another trigger with Sheet object and Clear All from Actions.

Re: Trigger not working

ramasaisaksoft — Wed, 09 Nov 2016 09:25:43 GMT

Hi Anil,

As per my understanding

if sheet 1,sheet 2 are there and ur trigger actions applicable in sheet1

once u went to sheet 2 you changed some other filters in sheet 2 so your sheet 1 charts are also changed as per your sheet 2 selections

but you want to see sheet 1 default settings (i.e on page open always one single value,1 month..etc)

Solution:-

Sheet 2 on leave the sheet trigger action clear all it will clear all selections once leave the sheet 2

and sheet 1 have your on page open triggers.

if i understand wrongly your requirement correct me.

Re: Trigger not working

Anonymous — Wed, 09 Nov 2016 09:32:13 GMT

Could it be that you do not have data loaded for the 1 selected month but when you select 3 months, the chart shows up because there is data availabile within the 3 months range?

What does your chart expressions look like?

Re: Trigger not working

dandaanilreddy — Wed, 09 Nov 2016 18:04:55 GMT

Thanks All for the reply.

I have a list box which i created by inline load i have applied always one selected value but when i hit clear the list box selection is getting cleared. . I heard that if the file is corrupted this will happen. Is it true? Can someone help me please.

Thanks

Anil

Re: Trigger not working

dandaanilreddy — Wed, 09 Nov 2016 19:16:28 GMT

Hi Tresesco

I have tried many ways but nothing worked. Below are my variables i wrote in trigger for my sheet.

Direct uplift

= If(ToggleSort=1,sum({<BillingRegionType = {"Direct"}>}growth_1_month),If(ToggleSort=2,sum({<BillingRegionType = {"Direct"}>}growth_3_month),

If(ToggleSort=3,sum({<BillingRegionType = {"Direct"}>}growth_6_month),If(ToggleSort=4,sum({<BillingRegionType = {"Direct"}>}growth_9_month)))))

Intluplift

= If(ToggleSort=1,sum({<BillingRegionType = {"INTL"}>}growth_1_month),If(ToggleSort=2,sum({<BillingRegionType = {"INTL"}>}growth_3_month),

If(ToggleSort=3,sum({<BillingRegionType = {"INTL"}>}growth_6_month),If(ToggleSort=4,sum({<BillingRegionType = {"INTL"}>}growth_9_month)))))

uschnneluplift

= If(ToggleSort=1,sum({<BillingRegionType = {"US Channel"}>}growth_1_month),If(ToggleSort=2,sum({<BillingRegionType = {"US Channel"}>}growth_3_month),

If(ToggleSort=3,sum({<BillingRegionType = {"US Channel"}>}growth_6_month),If(ToggleSort=4,sum({<BillingRegionType = {"US Channel"}>}growth_9_month)))))

IVFuplift

= If(ToggleSort=1,sum({<BillingRegionType = {"IVF"}>}growth_1_month),If(ToggleSort=2,sum({<BillingRegionType = {"IVF"}>}growth_3_month),

If(ToggleSort=3,sum({<BillingRegionType = {"IVF"}>}growth_6_month),If(ToggleSort=4,sum({<BillingRegionType = {"IVF"}>}growth_9_month)))))

vINTLTerritory

= If(ToggleSort=1,max({<BillingRegionType = {"INTL"}>}max_territory_cnt), If(ToggleSort=2,max({<BillingRegionType = {"INTL"}>}max_territory_cnt),

If(ToggleSort=3,max({<BillingRegionType = {"INTL"}>}max_territory_cnt), If(ToggleSort=4,max({<BillingRegionType = {"INTL"}>}max_territory_cnt)))))

vDirectTerritory

= If(ToggleSort=1,max({<BillingRegionType = {"Direct"}>}max_territory_cnt),If(ToggleSort=2,max({<BillingRegionType = {"Direct"}>}max_territory_cnt),

If(ToggleSort=3,max({<BillingRegionType = {"Direct"}>}max_territory_cnt),

If(ToggleSort=4,max({<BillingRegionType = {"Direct"}>}max_territory_cnt)))))

vIVFTerritory

= If(ToggleSort=1,max({<BillingRegionType = {"IVF"}>}max_territory_cnt),If(ToggleSort=2,max({<BillingRegionType = {"IVF"}>}max_territory_cnt),

If(ToggleSort=3,max({<BillingRegionType = {"IVF"}>}max_territory_cnt),If(ToggleSort=4,max({<BillingRegionType = {"IVF"}>}max_territory_cnt)))))

vUSChnnl Territory

= If(ToggleSort=1,max({<BillingRegionType = {"US Channel"}>}max_territory_cnt),If(ToggleSort=2,

max({<BillingRegionType = {"US Channel"}>}max_territory_cnt), If(ToggleSort=3,

max({<BillingRegionType = {"US Channel"}>}max_territory_cnt),If(ToggleSort=4,max({<BillingRegionType = {"US Channel"}>}max_territory_cnt)))))

I took the toggle as list box and applied always one selected value but when i hit clear button the list box is getting cleared. Can you please help me with this.

Thanks

Anil