Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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;
Hi Puskar,
You can try this attachment,
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.
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.
Now you can try this attachment,
no, its not opening.
PFA
No, Its still the same. It says I cant open this file since this has been prepared over an personal edition in another desktop.