topic Re: How to create a trigger on Clear All button in the navigation tool bar in QlikView

How to create a trigger on Clear All button in the navigation tool bar

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

Hi Team,

I am facing a issue in my application.

I have 4 charts in one of the sheets in application.

When Activating that sheet, i have added a trigger for the field Reportmonth as Month(today()).

Also, i have a text box in the home page. I have added a trigger to this too as Reportmonth =Month(today()). when user clicks on this text box, he will be reaching the sheet which has 4 chats.

when i reached the sheet which is having 4 charts, the report month is initially having the current month as expected.

Note: I have a field called "Time measure" with the values "MAT", "QTD", "YTD". when user selecting any other fields values and coming back to the selection MAT by clicking on Clear all, the report month selection is also cleared.

Can anyone help me like, is there any possibility to retain the report month value as the current month even user changes selection in the other fields or clicks on clear all button.

Your reply will be very helpful to me in a great extent.

Regards

Srinivas

Re: How to create a trigger on Clear All button in the navigation tool bar

vinieme12 — Fri, 05 Aug 2016 16:31:45 GMT

Add another Action to your MAT to select the reportmonth

Re: How to create a trigger on Clear All button in the navigation tool bar

vishsaggi — Fri, 05 Aug 2016 16:35:41 GMT

Add another action in the Clear All Button. Like

Re: How to create a trigger on Clear All button in the navigation tool bar

vinieme12 — Fri, 05 Aug 2016 16:44:55 GMT

Correct

Re: How to create a trigger on Clear All button in the navigation tool bar

konidena — Fri, 05 Aug 2016 17:14:49 GMT

Thanks for your reply.

You didn't understand my question.

I have already added to the trigger to the field "Time measure" field. MAT is the value in that field.

Now, I am clicking on the Clear All button in the navigation tool bar.

I don't have any application specific button created in my application.

Regards

Srinivas

Re: How to create a trigger on Clear All button in the navigation tool bar

vishsaggi — Fri, 05 Aug 2016 17:45:39 GMT

Would you mind sharing a sample app if possible ?

Re: How to create a trigger on Clear All button in the navigation tool bar

konidena — Fri, 05 Aug 2016 17:48:26 GMT

It is in client vpn.

not possible to bring it here. thanks you very much for your help.

is there any other ways to make it work.

Re: How to create a trigger on Clear All button in the navigation tool bar

vinieme12 — Fri, 05 Aug 2016 17:55:59 GMT

OK!

instead of using the ClearAll Button add a button with custom triggers, there is not work around for this.

Re: How to create a trigger on Clear All button in the navigation tool bar

vishsaggi — Fri, 05 Aug 2016 18:04:40 GMT

I cant think of anything apart from Setting Always one selected value on your ReportMonth Listbox. This way even if you clear all that selected value will be in selection mode.

Re: How to create a trigger on Clear All button in the navigation tool bar

Anonymous — Fri, 05 Aug 2016 18:09:42 GMT

How about your buttons / triggers setting a variable that can be used in Set analysis in your chart expressions. Thus when the variable forces the expression to evaluate for your report month it will override any selections made or cleared for month.

Re: How to create a trigger on Clear All button in the navigation tool bar

vinieme12 — Fri, 05 Aug 2016 18:12:00 GMT

Yes, that will be last selectedvalue though, not the ReportMonth.

Any reasons why you would not add a custom button?

Re: How to create a trigger on Clear All button in the navigation tool bar

konidena — Fri, 05 Aug 2016 18:31:08 GMT

I used set analysis expression in all my charts. Report month also part of this set analysis expression.

Basically, i am calculating the MAT (Moving annual total ) here.

Detailed Description:

Chart 1: X axis ( Dimension): Month Name

Y Axis: Sales

My chart should display 12 months on the x - axis when user select "MAT" value in the field "Time Measure".

This 12 months are : now we are in Aug. So, it should display from Sep 2015 to Aug 2016 on X axis.

for each month, the sales should be sum of its last 12 months including that month.

to achieve this , i used as of table concept.

Time Measure field values are : MAT, QTD, YTD

Already i made always one selected value in the "Time measure" field. When user selected MAT , i added a trigger to select the report month as current month.

Issue: When user selected other any of the other two values and other field values then , the report month value is cleared. Also, it is cleared when user click on "Clear All" button in the navigation tool bar.

Regards

Srinivas

Re: How to create a trigger on Clear All button in the navigation tool bar

settu_periasamy — Fri, 05 Aug 2016 18:33:03 GMT

did you tried with 'Set Clear State' Option

Re: How to create a trigger on Clear All button in the navigation tool bar

konidena — Fri, 05 Aug 2016 18:43:59 GMT

Hi All,

Somehow, I attached the scrambled values application here.

I am talking about the Competition analysis market level sheet.

Re: How to create a trigger on Clear All button in the navigation tool bar

settu_periasamy — Fri, 05 Aug 2016 18:47:03 GMT

Could you check it again?

There is a only one tab with blank