topic Re: Need help question in QlikView

Need help question

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

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,

Re: Need help question

sunny_talwar — Thu, 19 Oct 2017 11:33:22 GMT

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

Re: Need help question

vinieme12 — Thu, 19 Oct 2017 12:06:08 GMT

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

Re: Need help question

jadams123 — Thu, 19 Oct 2017 13:12:53 GMT

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]))}

Re: Need help question

jadams123 — Thu, 19 Oct 2017 13:15:08 GMT

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

2018 Q1 W1 Weekday 1

I have fields:

Year

Quarter No

Week No

Day

Re: Need help question

jadams123 — Thu, 19 Oct 2017 19:30:17 GMT

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)

Re: Need help question

jadams123 — Thu, 19 Oct 2017 19:34:23 GMT

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)