Selection invoices dated from today to 30 days ago

[#1]

Hello,

I am new to Qlikview and only had a couple of days of practice. Also, I am not very familiar with SQL-language. I have been able to make some basic reports/tables, but now I stumbled onto my first real problem.

I have made a selection of every invoice we have made. I do not wish to see all those invoices, just the ones dated between today (i.e. 22-06-2012) and thirty days ago (23-05-2012).

With the help of our IT-student I came to this result:

=

However, this did not work. Can anyone tell me what I'm doing wrong?

Kind Regards,

Freerk Wieringa

sum((<InvoiceDate = {'<=$(=Date(Today()-30,'DD-MM-YYYY'))}>}InvoiceValue)

[MayilVahanan]

Hi,

     Try this,

     =sum({<InvoiceDate = {'>$(=Date(Today()-30,'DD-MM-YYYY')) <= $(=Date(Today(),'DD-MM-YYYY'))'}>}InvoiceValue)

Hope it helps,

Mayil vahanan

[cesaraccardi]

Hi,

If the problem persists you can change the outer ' for ", because I'm not sure if the expression above will work when you have the ' in the format function.

Regards,

Cesar