topic Re: Need Help in QlikView

Need Help

jadams123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Everyone:

This is my code to get Week information.

=Sum( {$<YEAR = {$(#=Max(YEAR))}, [Week No]= {$(#=Max([Week No]))}, CT -= {ITC}, DCCF = {YES}>} AMOUNT)

I need to modify this code to say today()-1

thanks,

sunny_talwar — Wed, 01 Nov 2017 17:56:26 GMT

Do you have a date field in your app? What is it called? What is its format?

jadams123 — Wed, 01 Nov 2017 18:06:58 GMT

Yes I have a dimension called "Date" its mm/dd/yyyy

sunny_talwar — Wed, 01 Nov 2017 18:14:40 GMT

Then this

=Sum({$<Date = {"$(=Date(Today()-1, 'MM/DD/YYYY'))"}, CT -= {ITC}, DCCF = {YES}>} AMOUNT)