topic Re: get todays data in QlikView

get todays data

Thu, 07 Feb 2013 15:16:21 GMT

Hello

Ived made an variable called vDateToday which is based on Today()

This gives me the date today.

Now i want en expression to select on todays data - but i can get it to work.

I have have a listbox with todays date in i can easily select todays data only

my expression are as follow:

=sum({<Date_Clean={$(=(vDateToday))}, ReportDayEntry.Type={'EntryDownloadVisit'}>} ReportDayEntry.Antal)

But it returns 0

Date_Clean is in format YYYY-MM-DD

And my variable format is also YYYY-MM-DD

If i write this

=sum({<Date_Clean={'2013-02-07'}, ReportDayEntry.Type={'EntryDownloadVisit'}>} ReportDayEntry.Antal)

it works perfectly - but i dont want it hardcoded.

SunilChauhan — Thu, 07 Feb 2013 15:22:34 GMT

Try max

sum({<Date_Clean={$(=Max(Date_Clean))}, ReportDayEntry.Type={'EntryDownloadVisit'}>} ReportDayEntry.Antal)

sum({<Date_Clean={$(=Date(Today(),'YYYY-MM-DD'))}, ReportDayEntry.Type={'EntryDownloadVisit'}>} ReportDayEntry.Antal)

hope this helps

Thu, 07 Feb 2013 15:27:43 GMT

non of the two statement works

SunilChauhan — Thu, 07 Feb 2013 15:29:36 GMT

if possible share sample file

Thu, 07 Feb 2013 17:26:08 GMT

file is shared now - hope you can help

Gysbert_Wassenaar — Thu, 07 Feb 2013 18:29:13 GMT

Try this:

sum({<Date_Clean={'$(vDateToday)'}, ReportDayEntry.Type={'EntryDownloadVisit'}>} ReportDayEntry.Antal)

Thu, 07 Feb 2013 18:31:16 GMT

That worked for me! Thanx ! How come this work, and the other expression doesnt??? Is it due to its a string??

Thu, 07 Feb 2013 19:36:03 GMT

Do you know how i can get 7 days back? So i can show in a chart the last 7 days?

Thu, 07 Feb 2013 19:55:39 GMT

can i make a variable that takes 7 days back (not the 31, but the 7,6,5,4,3,2,1)

Thu, 07 Feb 2013 20:59:02 GMT

u posted something, but it only takes from the 31 of january?