topic Re: Only values associated with most current loaded date in QlikView

Only values associated with most current loaded date

ingoniclas — Mon, 24 Jun 2013 10:34:33 GMT

Hi there,

I am desperately looking for a solution to this issue: I want to filter only for those values associated with the most current loaded date. For example when 1st March 2013 ist the most current date loaded, I want to filter for only those values associated with this date. The result should look like this:

date value

01-03-2013 A

01-03-2013 C...

I tried it with max(date) and firstsortedvalue(date,-date), but this brings up ALL values with their most current dates like this:

date value

01-03-2013 A

01-01-2013 B

01-03-2013 C...

Does anyone know how to solve this issue in script or charts? Thanks!

Re: Only values associated with most current loaded date

luciancotea — Mon, 24 Jun 2013 10:37:34 GMT

=if( max(Date) = max(ALL Date), 1, 0)

Re: Only values associated with most current loaded date

Gysbert_Wassenaar — Mon, 24 Jun 2013 10:40:33 GMT

You could create a variable vMaxDate: =max({1} date)

Then you can use the variable in expressions. For example sum({<date={'$(vMaxDate)'}>} value)

Re: Only values associated with most current loaded date

ingoniclas — Wed, 26 Jun 2013 14:38:27 GMT

Thanks. That sounds very good. Where and how do you have to put in that statement? I tried to add Let vMaxDate =max({1} date) right after the system variables but it doesn't work this way. Unfortunately, I am not so familiar with variables, can you help? Thanks.

Re: Only values associated with most current loaded date

ingoniclas — Wed, 26 Jun 2013 14:40:01 GMT

This worked fine in the charts, thanks! Do you also have an idea how this can be achieved in the script?