topic Re: Set clear state on a variable in QlikView

Set clear state on a variable

mishraamit2485 — Mon, 19 Oct 2015 11:48:22 GMT

Hi All, Can we set a clear state on a button the action behind that button action behind that button is to select current month out of all the months.

Suppose I'm hitting clear button so this month its should go on Oct next month it should go on Nov.

Currently what is happening it is storing this month(Oct) when i'm setting the clear state where as next month also it is Oct only...i want something where it selects dynamic selection(Oct this month Nove next), instead of static (Stores Oct) only.

Re: Set clear state on a variable

Anonymous — Mon, 19 Oct 2015 11:52:34 GMT

how about a Trigger as yourmonthfield "=month(today())" on your button object?

Re: Set clear state on a variable

jsingh71 — Mon, 19 Oct 2015 11:55:04 GMT

use this:

vVariable = Month(Today())

This will store the current month. Use Select in Field action on clear button.

Field is your Month Filed and condition will be : =Month = Month(Today())

Re: Set clear state on a variable

mishraamit2485 — Mon, 19 Oct 2015 11:57:26 GMT

Data is not driving from the system date, I have to use that data which is coming from backend, it might be yesterdays data on today's date, i have to use that only.

Re: Set clear state on a variable

jsingh71 — Mon, 19 Oct 2015 12:03:26 GMT

You need to compare this date with your script data date.

Re: Set clear state on a variable

neha_sri — Mon, 19 Oct 2015 12:19:14 GMT

you can add trigger . On open add action>Select in field>, your field name and in search string

=month(Today())

Regards,

Neha

Re: Set clear state on a variable

mishraamit2485 — Mon, 19 Oct 2015 12:25:03 GMT

Attached the sample app, instead of Month i need to select quarter, and that too the numbers we are getting from the database.

Re: Set clear state on a variable

mishraamit2485 — Mon, 19 Oct 2015 12:31:16 GMT

Hi Neha, attached the sample app, please check..instead of month i need to select latest qtr which i coming from db

Re: Set clear state on a variable

Anonymous — Mon, 19 Oct 2015 12:43:10 GMT

please define a trigger on open document like below

= max({1}Qtr) -> if you want the latest quarter to be selected

be aware if you have more than 1 year you Need to select last year first

Re: Set clear state on a variable

mishraamit2485 — Mon, 19 Oct 2015 12:45:15 GMT

I want this on clear not on open document , when i hit the clear button it should go on the current qtr.

Re: Set clear state on a variable

Anonymous — Mon, 19 Oct 2015 12:53:32 GMT

then you need to do the following steps

1) provide a short macro: (press strg+M)

Sub DefineClearState
ActiveDocument.SetClearState
End Sub

2) define a Trigger on your sheet with Action run macro and define macro "DefineClearState"

Re: Set clear state on a variable

mishraamit2485 — Mon, 19 Oct 2015 12:54:52 GMT

Here is the dead end , i can not use macro n all....

Re: Set clear state on a variable

Anonymous — Mon, 19 Oct 2015 12:59:00 GMT

then try this:

- unselect month, quarter etc.

- use Trigger as mentioned in my Image on open document

- save doc

- when you open it will select latest quarter. if you Change to other quarter and press "clear" the latest quarter will be selected again

Re: Set clear state on a variable

mishraamit2485 — Mon, 19 Oct 2015 13:12:40 GMT

i tried the way you are telling, its going to 2nd qtr only..

Re: Set clear state on a variable

Anonymous — Mon, 19 Oct 2015 13:20:28 GMT

curious, when I follow your instructions Step1 and 2 I see quarter 3 after clear button???

upps, not allowed to upload

Re: Set clear state on a variable

mishraamit2485 — Mon, 19 Oct 2015 13:27:23 GMT

How i'm doing do the step 1, set the clear state on max qtr(which is 2 in this case), now follow the step 3 reload the doc, when you open 3rd qtr will be selected now select any month in (4,5,6) hit clear it will go to 2nd qtr only..

I have setup trigger on open max({1}Qtr)

Re: Set clear state on a variable

Anonymous — Mon, 19 Oct 2015 13:31:46 GMT

see attached app, when I follow your steps I get correct result

Re: Set clear state on a variable

mishraamit2485 — Mon, 19 Oct 2015 13:35:37 GMT

Strange...where is the attached app?

Re: Set clear state on a variable

Anonymous — Mon, 19 Oct 2015 14:09:25 GMT

Hi Amit,

Load a Quarter field with the following script.

'Q'&(FLOOR(NUM(MONTH(date Filed from DB)-1)/3)+1) AS Quarter,

and then in front end On clear Button set action

Select In Field-->Quarter

and in search string give this --> ='Q'&(FLOOR(NUM(MONTH(max(date Filed from DB))-1)/3)+1)

It will select the latest quarter in Quarter field based on Date field from DB.

Re: Set clear state on a variable

mishraamit2485 — Mon, 19 Oct 2015 15:46:04 GMT

I already have quarter codes there like 2015Q4 and 2016Q1, whit this data value i'm deriving the current qtr and previous qtr from that(using set analysis)..now I have to take max of it?