topic Re: Actual year and month selected by default on a view of Qlikview in QlikView

Actual year and month selected by default on a view of Qlikview

Tue, 10 Jan 2012 20:16:00 GMT

Hello, My name is Natacha De la Rosa, I'm from Dominican Republic and i'm beggining to develop with qlikview.

So this is my question, I have a view that is displayed by year and month, and I want to put by default selected the actual year and month. Is that posible? and if the answer is yes. How can begin with that?

Actual year and month selected by default on a view of Qlikview

Oleg_Troyansky — Tue, 10 Jan 2012 20:19:22 GMT

You can set 2 Variables for the current Year and Month in the Load Script, and then create Actions to select those values in the corresponding Fields upon opening the document:

Open "Settings" - "Document Properties" - Triggers.

Find the event "OnOpen" and enter the Actions editor. In the actions, pick "Select in field" and fill out the Field name and the Value (coming from the Variable).

This might be a bit too much for a beginner...

Actual year and month selected by default on a view of Qlikview

Tue, 10 Jan 2012 20:20:30 GMT

Hi, Nice to meet you.

Yes it's possible. If you want a static solution it's really simple. You just need to select the month and the year. Save and close your application. When you open it again, the selectin stay. Qlikview open the application with the selection saved.

Do you need a dynamic solution??

Re: Actual year and month selected by default on a view of Qlikview

Tue, 10 Jan 2012 20:23:17 GMT

Oleg Troyansky, thanks for answer, could you explain me a little more simple, like I write before, i'm beggining so could you help me at this point please.

EvaPOLINI, thanks for answer, I need a dynamic solution for this, What you recommend me?

Actual year and month selected by default on a view of Qlikview

Tue, 10 Jan 2012 20:26:52 GMT

Who?

Re: Actual year and month selected by default on a view of Qlikview

Tue, 10 Jan 2012 20:30:45 GMT

who could guide me with this?

Actual year and month selected by default on a view of Qlikview

Tue, 10 Jan 2012 20:58:18 GMT

Can I do this with javascript and if the answer is yes, how can I do it?

Actual year and month selected by default on a view of Qlikview

Oleg_Troyansky — Tue, 10 Jan 2012 21:02:03 GMT

Natacha,

you might require a bit more detailed support than this forum is built for... We usually show you the right direction...

What part of the solution do you need help with?

Setting the variables in the script:

let vCurrentYear = year(today());

let vCurrentMonth = Month(today());

I described the rest in my previous post

best,

Oleg

Re: Actual year and month selected by default on a view of Qlikview

Tue, 10 Jan 2012 21:17:21 GMT

I did the example with your month = MonthNames (describe in the script beginning)

1Open the script

2 add that in the script (anywhere):

let varYear =year(today());

let varMonth= Month(today());

3Save and close your script.

4Go in Settings -> Document properties -> Triggers.

5 click "On Open" in Document Event Triggers

6 click "Add action(s)"

7 click "Selection" in Action Type and "Select in field" in action

8 Click "ok"

9 Type your year field name in Field and "=varYear" in Search String

10 click "Add action(s)"

11click "selection" in action type and "select in field" in action

12 click "ok"

13 Type your year field name in field and "=varMonth" in Search string

14 click "ok" and "ok",

15 save and close the application

16 open it.

Is it working/ For yhe year? the month?

If it's not working for the month, could you give me the format month?

Re: Actual year and month selected by default on a view of Qlikview

Thu, 12 Jan 2012 13:31:51 GMT

Hello, I tried the example that you give me,works with the year but the month doesn't work, the month format is numeric.

Re: Actual year and month selected by default on a view of Qlikview

Thu, 12 Jan 2012 14:02:07 GMT

Like I said in the last sentence of my previous message. It's probably because yours formats don't match. wou will need to adapt varMonth to your month format. could you tell us if you use the long name, the short name, the number month??

Re: Actual year and month selected by default on a view of Qlikview

Thu, 12 Jan 2012 14:05:46 GMT

I use the number month, how could I adapt the format to the variable.

Actual year and month selected by default on a view of Qlikview

Thu, 12 Jan 2012 14:18:12 GMT

there are a lot of date functions, you will find it in the reference manual. for exemple you can take your month number, make a date with that and apply Month().

It's depend of your variable MonthNames.

You have to lookng for in the manual to find witch one is adapt to your case.

Actual year and month selected by default on a view of Qlikview

Thu, 12 Jan 2012 15:29:09 GMT

EvaPOLINI, thanks you very much!!!! I did it !

Re: Actual year and month selected by default on a view of Qlikview

Tue, 22 Jul 2014 15:42:46 GMT

Also just started developing in QlikView. Following the above I have set a variable of current financial yesr as the selection on opening. I presume that with a variable for the previous financial year I should be able to open with both previous and current year selected. What statement would I need in the search string to combine the two variables.

Thanks for any help.

Re: Actual year and month selected by default on a view of Qlikview

Wed, 06 Aug 2014 02:21:52 GMT

Hi Gareth,

sorry for the delay,

Could you confirm to me something. You try to open your app with 2 values selected in the Year (CY, PY).

Am I right?

Cheers,

Eva

Re: Actual year and month selected by default on a view of Qlikview

Mon, 11 Aug 2014 08:49:36 GMT

Hi Eva

That is correct. I have established how a variable can be set in the trigger but I want to open the app with two variables, CY and PY, active.

Many thanks,

Gareth

tel: 01206 746530

email: gareth.rees@colchesterhospital.nhs.uk<mailto:gareth.rees@colchesterhospital.nhs.uk>

secure email: gareth.rees2@nhs.net<mailto:gareth.rees2@nhs.net>