Need help question

[jadams123]

How do I get todays sales..

tried many different ways none are working. I am sure its pretty easy.

this is my week formula

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

Also I want to create a text box that outputs:

2018 Q1 W1 Weekday 1

so current year, current quarter, current week, current weekday

weekday 1 is (Sunday)

Thanks,

J

[sunny_talwar]

Don't you have a date field which can be used here within set analysis?

[vinieme12]

Create a master calendar from your Date field, if you need sales by date or period! then you will always have a date type  field in your data

Better Calendar Scripts | Qlikview Cookbook

[jadams123]

Yes I do have a date field

its called "Date"

I just gave an example of week. So I don't know how to date()..

Date={(#=max(date()))}

[Week No]= {$(#=Max([Week No]))}

[jadams123]

Also if you can show me how to do this...

2018 Q1 W1 Weekday 1

I have fields:

Year

Quarter No

Week No

Day

[jadams123]

almost there:

But I want sunday as 1

='FY'&Max(Year)&' '&'Q' & Max([Quarter No])&' ' &'P'&Max(Period)& ' '&'WK'&Max([Week No])&' '&'WKDAY'&Num(WeekDay(Today()),'#')

Still havnt figured out

instead of week how to do today()-1

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

[jadams123]

Figured it out atleast for this:

='FY'&Max(Year)&' '&'Q' & Max([Quarter No])&' ' &'P'&Max(Period)& ' '&'WK'&Max([Week No])&' '&'WKDAY'&Num(Dual(Subfield('$(DayNames)',';',WeekDay(Today())+1),Mod(Today()-1,7)),'#')

"FY2018 Q1 P3 WK12 WKDAY4"

Not sure if there is a easier way.

*******Still haven't figured out*********

instead of week how to do today()-1

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