Trigger not working

[dandaanilreddy]

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

[hemanthaanichet]

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

[tresesco]

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

[Anonymous]

Hi ,

Can you share related document  .

[Anil_Babu_Samineni]

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.

[ramasaisaksoft]

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.

[Anonymous]

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?

[dandaanilreddy]

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

[dandaanilreddy]

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