topic Re: Tricky Requirement in QlikView

Tricky Requirement

Thu, 08 Nov 2012 17:05:48 GMT

I have 4 fields Appointdate,ClosingDate, SubmitDate,ApprovalDate....all these fields have dates as field values......Now in my dashboard I need a Listbox showing all these 4 date fields.....and I have to use Year, Month and Day as Time filters in my dashboard........Now If I select Appointment date(any field), all the time filters should work according to Appointment Date only......i.e all the date on the dashboard sould be associated only with appointmentdate with respect to selected Time filters........

Re: Tricky Requirement

Thu, 08 Nov 2012 18:49:24 GMT

See if the attached file is what you had in mind. The calendar changes according to what the user selects in the drop-down box.

Re: Tricky Requirement

Thu, 08 Nov 2012 20:32:05 GMT

Thankyou so much for your response.....I am trying to do same as you did with my excel file.....but I am not getting any results in time filter

Re: Tricky Requirement

Thu, 08 Nov 2012 20:34:59 GMT

I am taking two date fields APPOINTMENTDATE and HUDAPPROVALDATE

Re: Tricky Requirement

Thu, 08 Nov 2012 20:41:55 GMT

I tried your qvw and for some reason it was saying that vDate was invalid. But when I rewrote the expression, it worked fine:

=if(VDate='HUDAPPROVALDATE',HUDAPPROVALYEAR,
if(VDate='APPOINTMENTDATE',APPOINTMENTYEAR))

Re: Tricky Requirement

Thu, 08 Nov 2012 20:42:56 GMT

Found the problem - you had vDate in the expression, but your variable name is VDate. It is case sensitive.

Re: Tricky Requirement

Thu, 08 Nov 2012 21:43:12 GMT

Thankyou Once again for your time and help.........its working