Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Need Help

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,

J

3 Replies
Highlighted

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

Highlighted
Creator
Creator

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

Highlighted

Then this

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