Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How to clear input box values?

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

12 Replies
Highlighted
Creator II
Creator II

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.

Highlighted
Creator III
Creator III

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;

Highlighted
Partner
Partner

Hi Puskar,

You can try this attachment,

Highlighted
Contributor III
Contributor III

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.

Highlighted
Contributor III
Contributor III

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.

Highlighted
Partner
Partner

Now you can try this attachment,

Highlighted
Contributor III
Contributor III

no, its not opening.

Highlighted
Partner
Partner

PFA

Highlighted
Contributor III
Contributor III

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