How make filter selections set to default

[Anonymous]

Hi

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

[prieper]

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

[Anonymous]

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?

[Anonymous]

Any help on this??

[#5]

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.

[rwunderlich]

See this post for some tips:

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

[Anonymous]

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....

[Oleg_Troyansky · Accepted solution]

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.