Input box as date range in Personal Edition

[#1]

Hi,

I have recently installed QlikView 9.0 Personal Edition and am a newbie to Qlik View.

I need to have a variable which would show up as a drop down with date range values having future dates ( e.g. all 5 days from current date). I understand from Qlik View Help that this would be handled via expressions using an input box.,please correct me if i am wrong.

When user selects the value in this input box date range, then a straight table chart would need to be updated to display all those rows where a particular date column has dates lying between the date range i.e. between current date and date value selected in the input box.

Can anyone help me on how to do this in Qlik View 9.0 Personal Edition? I basically need to know how to create such an input box date range and then trigger values selection in straight table chart according to what is selected in input box date range.

Request that if anybody attaches example .qvw files then it should be such that it can open on the Qlik View 9.0 Personal edition on my machine.

Appreciate any help.

Thanks and regards

Anurag

[#2]

Yes ,its possible . go through my application. But i have used if condition. I ain't sure about set expression though.

[boorgura · Accepted solution]

Anurag,

I came across a somewhat similar situation.

I used a calendar object which is linked to a variable (say PikDate).

And then we can set the min and max values for it.

In your case max value can be Today() + 10 - To have next 10 days available.

and on your table you can have the calculations based on that variable (PikDate)

Let me know if it works or not.

[#4]

Rocky,

Many thanks for your suggesstion. I used a calendar object with a variable as you mentioned and currently it works for me now.

naive123,

I tried to open your .qvw file on my Personal Edition, but it currently doesnot open saying that this document has been recovered more times than is allowed to be done by Personal Edition. Meanwhile i could work with Rocky's idea, appreciate your inputs.

Really appreciate the help.

Thanks

Anurag