topic Re: How to reflect dates in calender boxes in QlikView

How to reflect dates in calender boxes

Anonymous — Sun, 06 Mar 2016 23:48:49 GMT

Please find the attached application , this is in regards to Date filters , my date filters works fine , but the user is confused as when selections are cleared and a group is selected , it shows all values in the group irrspoective of group , can it just select the group values for the date values shown in the start and end date filters ?

Example : I selected Feed from group , it is showing all values for all dates in the table box, where as calendar doe snot show same.

Thanks

Radhika

Re: How to reflect dates in calender boxes

sunny_talwar — Mon, 07 Mar 2016 00:28:41 GMT

Which calendar are you talking about?

Re: How to reflect dates in calender boxes

swuehl — Mon, 07 Mar 2016 00:30:48 GMT

Maybe like attached?

Re: How to reflect dates in calender boxes

Anonymous — Mon, 07 Mar 2016 01:26:45 GMT

I am talking about calendar boxes on the left hand side at the Top , the date pickers.

Swehl , I see Function has been removed from the table , I want it to be displayed.

My issues is say for example I select a Group , I should be able to select a Function from the Table , which I can do with my existing expressions , but when I select a new Group and deselect the Group I selected earlier, my date filter does not work .. I mean I can see all the data for the Group I selected later even though the Date pickers show past 7 days Dates. that is confusing. How can I fix this?

Re: How to reflect dates in calender boxes

swuehl — Mon, 07 Mar 2016 01:37:17 GMT

I haven't removed a column from any table. I've just set the clear state to use the variables in date selection.

But this won't help when you clear e.g. the date field explicitely or by selecting another field's excluded value.

You may use triggers on changes in field selections, but this can get pretty messy.

[Or maybe just have a trigger watch the date field and set the variable values accordingly]

Or don't use the calendar objects bound to variables.

Re: How to reflect dates in calender boxes

Anonymous — Mon, 07 Mar 2016 01:47:34 GMT

I am sorry , its my bad.. I attached a wrong application. Attached the corrected one again , can you please elaborate on

"Or maybe just have a trigger watch the date field and set the variable values accordingly" and also what other options do I have to bound the variables?