topic Default selections in QlikView

Default selections

Thu, 28 Oct 2010 09:47:34 GMT

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,

Default selections

Thu, 28 Oct 2010 10:05:09 GMT

try max(year_quarter) under document settings/actions

therefore try to combine both fields to year&quarter as year_quarter

Default selections

raghavsurya — Thu, 28 Oct 2010 11:16:43 GMT

Hi Tims,

Please use below query. I have assumed cost as the field for which u want to get the sum.

Sum({< Year={$(=Max(Year))}, Quarter={$(=Max(Quarter))}>}(Cost))

Regards,

Raghav

Default selections

Thu, 28 Oct 2010 12:25:51 GMT

Hi,

I Think that fields YEAR and QUARTER are a derivation of a just field;

Load

your_date,

YEAR(your_date) as YEAR,

NUM(MONTH(your_date)) / 3 AS QUARTER

FROM your_table;

You just need to set this field (your date), with the max value using the function "MAX()"

In Document Properties, Tab Triggers, select in "Document Event Triggers" option "OnOpen" and add a action. Action Type: "Selection" and "Select in Field"

insert the name of FIELD that you want (your_date) and in "Search String" put "=MAX(your_date)".

When your document is open, the max date will be select, and the MAX YEAR and MAX QUARTER too.

Default selections

Thu, 28 Oct 2010 12:32:03 GMT

Hi Daniel,

I am using 8.2 version, so I did not see this option.

am I right the option not available in 8.2?

Thanks,

Default selections

Thu, 28 Oct 2010 13:24:25 GMT

Hi Tim,

you are right, this function is only available since version 9.0.

Maybe you could build a workaround with variables and macros to simulate qlikview's internal actions.

However, I would recommend to update to v9 or v10, because additional functions are worth this one time effort and will save a lot of programming work

Regards, Daniel

Default selections

Thu, 28 Oct 2010 13:58:41 GMT

If you want, this function can be create with MACRO

Default selections

Fri, 29 Oct 2010 08:46:15 GMT

Thanks but I am not familiar with Macro's.

If you can give some idea, will try to implement the same.

Thanks,

Default selections

Fri, 29 Oct 2010 12:10:25 GMT

Hi,

Press CTRL + M in your Document and open "Edit Module".

Paste the code and will be create a macro function to select the max value in your especific field:

SUB SELECT_MAX_DATE

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

END SUB

Press button Check and OK to create the function.

After create function go to Document Properties and tab MACRO. In Document event select a "On Open" and select your function "SELECT_MAX_DATE".

PRESS OK and save document.

When document open the max date will be select.

Default selections

Mon, 01 Nov 2010 12:37:57 GMT

Thanks Correa,

Its working fine, but suppose if my dashboard have two tabs and each tab is using different xls files.

Then Do we have any options to define for two fields?

Thanks,

Default selections

Tue, 02 Nov 2010 06:03:21 GMT

Hi Experts,

Any idea on this??

Thanks,

Default selections

Wed, 03 Nov 2010 10:54:13 GMT

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)")

Default selections

Wed, 03 Nov 2010 12:51:30 GMT

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,

Default selections

Wed, 03 Nov 2010 12:58:43 GMT

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.

Default selections

Wed, 03 Nov 2010 13:11:35 GMT

Thanks Correa, it works perfect for me..

Thanks,

Default selections

Tue, 08 Feb 2011 16:07:50 GMT

Hi Correa,

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

Default selections

Wed, 09 Feb 2011 10:42:43 GMT

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

Thanks,

Default selections

Wed, 09 Feb 2011 12:19:32 GMT

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