Default selections

[#1]

Hi,

I have two fields Year and Quarter with the values of 2005, 2004, 2005, 2006, 2007

And Quarter is 01, 02, 03, 04

default selection should be 2007 and 04

Later If I add 2008 in Year field it should select 2008 and 04.

Any settings in properties.

Thanks,

[#2]

Hi Experts,

Any idea on this??

Thanks,

[#3]

Just repeat the command line with the new field

ActiveDocument.Fields("YOUR_FIELD_1").Select ActiveDocument.Evaluate("max(YOUR_FIELD_1)")

ActiveDocument.Fields("YOUR_FIELD_2").Select ActiveDocument.Evaluate("max(YOUR_FIELD_2)")

[#4]

Yeah Correa I did it already.

my question is I have to define two marco's when I select On Open in Document Event Triggers.

In Macro I can select only one but not two.

Thanks,

[#5]

Hi,

In this case, you need to define your command in a single MACRO.

SUB test_OnPen

CODE 1......

.....

CODE 2.......

......

END SUB

You just set a one function macro.

[#6]

Thanks Correa, it works perfect for me..

Thanks,

[#7]

Hi Correa,

Do you have any website/ materials which will teach me the basics of macro programming that can be used in Qlikview??

[#8]

Correa, me too required it will help to learning from scrach...

Thanks,

[#9]

Hi Guys,

the qlikview have a simple document that show how to use some macros and have examples too.

C:\Program Files\QlikView\Documentation\APIGuide.qvw

I use this to learn, but is a just basic functions.

For the expert macros do you need to learn about vbscript/macro that exists in EXCEL.

Thanks