topic How to clear input box values? in QlikView

How to clear input box values?

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to clear input box values?

khalander — Mon, 16 Jan 2017 04:34:31 GMT

Hi,

Please create one text object or button and create below actions.

1) Action Type= Select and Action = Select in field

In Filed Tab give filed name and in search string tab is empty

2) Action Type= Select and Action = Clear All

Hope it will work.

Re: How to clear input box values?

girirajsinh — Mon, 16 Jan 2017 05:34:26 GMT

if you leave both input box blank or you delete you previously entered value

and you have following sort of expression... you don't need to create any trigger. If you leave both boxes blank, following expression will get you all the records in table

sum({<StartDate={">=$(vInputbox1)<=$(vInputbox2)"}>} YourMeasureField)

I defined following in script

let vInputbox1=2016-02-25;

let vInputbox2=2016-02-30;

Re: How to clear input box values?

susovan — Mon, 16 Jan 2017 05:41:12 GMT

Hi Puskar,

You can try this attachment,

Re: How to clear input box values?

Anonymous — Mon, 16 Jan 2017 06:02:02 GMT

Hi there,

I don't think you will be able to clear input fields with the help of buttons. The way I would suggest you is you manually trigger the input being specific, you manually delete your entry and set the blank value pressing enter before editing the other value.

I hope this will work.

Re: How to clear input box values?

Anonymous — Mon, 16 Jan 2017 06:05:54 GMT

Since this report was made over QlikView personal edition, I guess only you can open the report. My QlikView doesn't open this file as the personal edition of mine opens the reports I have created on my PC.

Re: How to clear input box values?

susovan — Mon, 16 Jan 2017 06:13:44 GMT

Now you can try this attachment,

Re: How to clear input box values?

Anonymous — Mon, 16 Jan 2017 06:25:44 GMT

no, its not opening.

Re: How to clear input box values?

susovan — Mon, 16 Jan 2017 06:35:46 GMT

PFA

Re: How to clear input box values?

Anonymous — Mon, 16 Jan 2017 06:46:14 GMT

No, Its still the same. It says I cant open this file since this has been prepared over an personal edition in another desktop.

Re: How to clear input box values?

susovan — Mon, 16 Jan 2017 06:55:13 GMT

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)

)

Re: How to clear input box values?

tresB — Mon, 16 Jan 2017 06:57:09 GMT

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.

Re: How to clear input box values?

Anonymous — Mon, 16 Jan 2017 07:02:41 GMT

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