topic How make filter selections set to default in QlikView

How make filter selections set to default

Anonymous — Mon, 07 Mar 2011 22:24:36 GMT

I have multiple charts with various filters , i want to make some of the filter values set to default , i mean something like if i click on a button say Default , all the specified filter values must set to default selection.How do i achive this?

And also as i was adding tabs the performance of my application has been reducing,more calculation less performance...how do i handle this...

Please Suggest....

Thank you

How make filter selections set to default

prieper — Mon, 07 Mar 2011 22:29:09 GMT

1. Make a macro - clear all values and then set your desired ones. Alternatively you may use (in version 10) the "Clear"-button, wich resets to the initial state.
2. close all graphs. Additionally you may show them only subj to conditions (less than xxx values selected or the like)

HTH
Peter

How make filter selections set to default

Anonymous — Mon, 07 Mar 2011 22:34:57 GMT

Thank you for the reply ,

Actually i have'nt created Macro anytime , and i am using version 9 , could you please point me to a sample app to show how to achive this?

How make filter selections set to default

Anonymous — Wed, 09 Mar 2011 00:36:25 GMT

Any help on this??

How make filter selections set to default

Wed, 09 Mar 2011 01:14:39 GMT

If you want this implemented using macro you can do the following:

1. To clear all selected values you can issue this statement in your macro.

ActiveDocument.ClearAll false

The false (or true) parameter tells QV whether to clear the "locked" selections or not.

2. To set the selected value you can do something like this:

set fld = ActiveDocument.GetField("<YourField>")
set fldVal = fld.GetNoValues
fldVal.Add
fldVal(0).Text = "<YourSelectionValue>"
fld.SelectValues fldVal

If the field is numeric you also need to set the following properties before the actual SelectValues

fldVal(0).Number = "<YourNumericValue>"
fldVal(0).IsNumeric = true

The sample macro would look like:

Public Sub SetDefaultValue
ActiveDocument.ClearAll false
set fld = ActiveDocument.GetField("<YourField>")
set fldVal = fld.GetNoValues

fldVal.Add
fldVal(0).Text = "<YourSelectionValue>"

if fld.GetProperties.IsNumeric then
fldVal(0).Number = "<YourNumericValue>"
fldVal(0).IsNumeric = true
else
fldVal(0).IsNumeric = false
end if

fld.SelectValues fldVal
End Sub

I hope this helps.

How make filter selections set to default

rwunderlich — Wed, 09 Mar 2011 05:51:05 GMT

See this post for some tips:

http://qlikviewnotes.blogspot.com/2010/02/setting-initial-selections-in-version-9.html

How make filter selections set to default

Anonymous — Thu, 10 Mar 2011 00:42:32 GMT

Thank you very much , so i am using Qlikview 9 , implementing action to get the book mark , Here is the sample document of what i am trying to achive....

How make filter selections set to default

Oleg_Troyansky — Thu, 10 Mar 2011 01:58:28 GMT

Besides applying the Bookmark, you could use Actions to clear selections and to make specific selections in certain fields.

Regarding your Calendar controls, they represent Variables, and those have nothing to do with the selected Fields or Bookmarks. Add another action to set the value of each Variable to the desired date.