topic Logic help in QlikView

Logic help

abhaysingh — Wed, 03 Dec 2014 09:53:56 GMT

right now month DEC 14 is running, here i am following Financial Year April to March,

when i go to Day Level and try to find max(date) of current month it is giving me 31st dec 14 but it should be 03-dec-14.

can any one help me in this.

if need master calender script i can provide that

Re: Logic help

jonathandienst — Wed, 03 Dec 2014 09:59:06 GMT

It seems you have loaded dates up to 31 Dec, so max(date) will return 31 Dec. Do you want the max(date) to be limited to today, or to dates containing transactions

=RangeMin(Today(), max(date))

=max({<date = {"=Count(Sales) > 0"}>} date) (fix field name to match your model)

HTH

Jonathan

Re: Logic help

jagadeesh_diamo — Wed, 03 Dec 2014 09:59:11 GMT

Can you please clarify which output you want? dynamic or standard?

If you want todays date, why dont you use today() function?