Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I extracted datas from my oracle database. These datas are in date format, so they look very similar to timestamp format.
So how I can compare them in QlikView? I only want to count the datas which are smaller than system time. My try looks like this:
=count({$<[HK_NAME_KURZ]={'BUDSTART'},[ANZAHL]={">=1"},[BAUP_DATUM_GUELTIG_BIS]={">$(=Timestamp(Now(2)))"}>} [KUNDE_BPR_ID])
Regards, Moe.
Oh, it was my fault. Syntax worked with only Now().
Oh, it was my fault. Syntax worked with only Now().