topic Re: Help with some Date filters in QlikView

Help with some Date filters

hopkinsc — Thu, 27 Feb 2014 17:48:25 GMT

Hi all,

I need some help creating some date filters.

I have attached a sample.

I want have created an inline table:

Date_Range

Curr Week

MTD

YTD

i need to know how i can get this to work correctly so when the user selects 'Curr Week' the data will change just to show the current week and so on.

I know i need to use variables but i am confused how it will work as the week no is a number whereas the MTD/YTD would be dates so i am unsure how to use the variable in set analysis.

Can anyone help please?

Re: Help with some Date filters

Thu, 27 Feb 2014 17:57:54 GMT

You might want to create a master calendar for this. You can just search the community for master calendar.

There is a video called "Creating a Master Calendar" . That should help you.

Thanks

Re: Help with some Date filters

hopkinsc — Thu, 27 Feb 2014 18:28:20 GMT

THanks. I already have a master calendar in my 'real' qvw. I have a put a simple calendar in my sample attached to my original question.

Any help with getting it working in my sample would be great.

Re: Help with some Date filters

Gysbert_Wassenaar — Thu, 27 Feb 2014 18:45:13 GMT

See attached qvd. Specifically the Select in Field action added to the OnSelect field trigger of the DateRange field. You can find it on the Triggers tab of the Document Properties window.

Re: Help with some Date filters

Thu, 27 Feb 2014 18:46:01 GMT

Sorry I didn't see your attached file. Now I get what you want to do.

I have created flags in The master Calendar Yes/No for those three currwee, YTD and MTD.

Check them out and see if it helps.

Thanks

Re: Help with some Date filters

hopkinsc — Thu, 27 Feb 2014 19:54:01 GMT

thanks guys. I am unable to test these until tomorrow. But I think I may have an issue with the field trigger option as we use SVN and there is an issue with SVN where when you save a qvw into SVN it clears out all variables and field triggers.

WE we have got around the variable issue by loading in all variables from a text file so they are part of the script. But I fo not believe there is a work around for field triggers.