topic Re: Set analysis using Today function in QlikView

Set analysis using Today function

helen_pip — Tue, 14 Jan 2014 09:43:47 GMT

Hello

I was wondering if someone could kindly cast an eye over my set analsyis statement as it currently returning Null values

My aim is to produce a sum of data for the current day. My dataset contains data for the entire quarter

My Test field returns data in this format: DD/MM/YYYY (14/01/2013)

My Today() functions returns values in this format DD/MM/YYYY (14/01/2013)

=SUM( {1<Test={$(=Date(Today(), 'DD/MM/YYYY'))}>}QuarterlyBreaches_Breaches)

Kind Regards

Helen

jonathandienst — Tue, 14 Jan 2014 09:53:31 GMT

Helen

try putting quotes around the date expression:

=SUM( {1<Test={"$(=Date(Today(), 'DD/MM/YYYY'))"}>}QuarterlyBreaches_Breaches)

HTH

Jonathan

helen_pip — Tue, 14 Jan 2014 09:57:06 GMT

Hello Jonathan

Thank you for your reply. You beat me to it, I had just found out about the "" quotes online and it now works perfectly

I was just about to re-post, so thank you for your reply

I am back on track again now

Thanks

Helen