Select table data from the condition input box value

Fri, 24 Jul 2015 08:58:29 GMT

Maybe it is very simple but i couldnt get the answer for more than 2 days.

sample data are like this

Date amount

2011-01-01 100

2011-01-02 200

2011-01-03 300

2015-01-05 400

2015-02-01 500

2015-03-01 600

I want get data from date range 2011-01-03~2015-02-01

2011-01-03 is getting from input box variable vDateFrom and 2015-02-01 from input box variable vDateTo.

Two variables numbur format is date(YYYY-MM-DD)

I used set operation

Sum( {<Date={">= $(vDateFrom) <=$(vDateTo)"} amount)

Expecting answer is 1200 of course but the result is null.

The curious thing is that if the table of Date type is 'YYYYMMDD' and varialbe number type is number(not date 'YYYY-MM-DD') then I could get the epected result.

Please show me the answer.

Thank you.

Re: Select table data from the condition input box value

pokassov — Fri, 24 Jul 2015 09:02:36 GMT

Sum( {<Date={">= $(=date(vDateFrom)) <=$(=date(vDateTo))"} amount)

topic Re: Select table data from the condition input box value in QlikView

Select table data from the condition input box value

Re: Select table data from the condition input box value