topic Doubt about dates in QlikView

Doubt about dates

Wed, 25 Mar 2015 16:34:49 GMT

Hi everybody

I have a list of properties and i have the purchase date

On the other hand i have the date in the link table

i wanna do this

See the property only if the purchase date is < to the selected date from the link table

Thank you all

Greetings

buzzy996 — Wed, 25 Mar 2015 16:38:51 GMT

try this,

create variable for selected date,

if(purchase date < variableselectedate,property,null())

Wed, 25 Mar 2015 16:39:59 GMT

what that's the part that i don't know how to do

with getfieldselections or something like that?

buzzy996 — Wed, 25 Mar 2015 16:42:05 GMT

pls share ur .qvw?

Wed, 25 Mar 2015 16:48:47 GMT

I can't!

What part didn't you understand?

Thu, 26 Mar 2015 09:38:10 GMT

try with this expression

GetFirstStoredValue