How to clear input box values?

[#1]

Hi All,

I have below data:

ID    StartDate                  EndDate               Balance

1      2016-03-23              2016-03-25           1000000

2      2016-01-03              2016-02-08           1034550

3      2015-08-19              2015-09-05           8989770

4      2016-02-27              2016-03-10           5600080

4      2015-11-25              2015-12-07           2300000

I am getting all the data in Qlikview StraithTable and writing sum(Balance) expression. Everything is working fine till here.

Now I want 2 manual input boxes where user can give a range of dates like -

Inputbox 1 value= 2016-02-25

Inputbox 2 value= 2016-02-30

So I created 2 variables and used both variables in these input boxes and I am getting the desired result(Only one record)

4      2016-02-27              2016-03-10           5600080

But if I want to see the all records then how can I achieve this as I am not able to clear both input boxes values hence I am always getting the result which is falling the both input date range.

Please help me on this.

Thanks

[susovan]

I have used below expression and variables on those application that I had send before.

Variables are:

vStartDate

vEndDate

Expression:

=if(Len(vStartDate)<=1 and Len(vEndDate)<=1,

Sum(Balance),

Sum({<StartDate={"$(vStartDate)"},EndDate={"$(vEndDate)"}>}Balance)

)

[tresesco]

Anirban,

With personal edition, you can't open qvw files created by others ( 4-times recovery is there though). However, there would be qvw files created by Qlik themselves with integrated key that can be opened by any personal edition qv software. That means, Susovan or anybody like use who are not from Qlik can't create a file that you can open with personal edition software.

Hope this helps.

[Anonymous]

I know, that's why I was not able to open it. Thus the screenshot helped me.