Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Selection invoices dated from today to 30 days ago

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)

2 Replies

Re: Selection invoices dated from today to 30 days ago

Hi,

     Try this,

    

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

    

Hope it helps,

Mayil vahanan

cesaraccardi
Valued Contributor

Re: Selection invoices dated from today to 30 days ago

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

Community Browser