Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MayilVahanan

Hi,

     Try this,

    

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

    

Hope it helps,

Mayil vahanan

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
cesaraccardi
Specialist
Specialist

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