topic Re: Default Selections while loading the document in QlikView

Default Selections while loading the document

Anonymous — Thu, 07 Feb 2013 19:13:28 GMT

Hi All,

I have requirement to display default selections when I am loading the document. I have a business date column when I load the document i want to be srtart date and end dates are populated below values so sales will be filtered on these filters.

Start Date: 08/01/2012

End Date: 08/30/2012.

Attached the QVW file..

Thanks

Dasu.G

Re: Default Selections while loading the document

Thu, 07 Feb 2013 19:33:06 GMT

Hi,

Pl find attched application..

Re: Default Selections while loading the document

Anonymous — Thu, 07 Feb 2013 20:09:48 GMT

Thanks for the response..

It is quite useful when we have these dates static. I forgot to mention one that that below mentioned dates are just example.

Start Date: 08/01/2012

End Date: 08/30/2012.

These fields are fiscal year start date and end date hence these values can change dynamically this solution won't work..

Re: Default Selections while loading the document

Gysbert_Wassenaar — Thu, 07 Feb 2013 20:17:54 GMT

You can use the OnOpen trigger also to add Select in Field actions. You can add variables to your document that calculate the fiscal dates. You can use these variables in the Search String.