topic Expression inside YTD formula in QlikView

Expression inside YTD formula

Saro_2306 — Fri, 15 Nov 2024 23:46:38 GMT

Hi all,

I need to show YTD values for Production / Working days for various Weeks in bar chart.

Currently using this formula

=sum({ < [WEEK NUM] = {">=$(=Yearstart(Max([WEEK NUM]))) <=$(=Max([WEEK NUM]))"}>} [PRODUCTION UNITS] ) /

Count({ < [WEEK NUM] = {">=$(=Yearstart(Max([WEEK NUM]))) <=$(=Max([WEEK NUM]))"}>} DISTINCT COMBINE1)

Any one help me to rewrite formula. Thanks in advance.

Kushal_Chawda — Tue, 20 Oct 2020 10:58:07 GMT

@Saro_2306 you are using yearstart over WEEK_NUM which is not valid. You need a Date field for that because here week_num is in number format.

In which format you want your end results? I mean which chart with Dimensions and measures

Saro_2306 — Tue, 20 Oct 2020 11:02:42 GMT

I Need results in Bar Chart. Weeknum is derived from Data using Week() formula in script.

benvatvandata — Tue, 20 Oct 2020 14:49:23 GMT

Maybe try:

=sum({ < [WEEK NUM] = {">=$(=Week(Yearstart(Max([WEEK NUM])))) <=$(=Max([WEEK NUM]))"}>} [PRODUCTION UNITS] ) /

Count({ < [WEEK NUM] = {">=$(=Week(Yearstart(Max([WEEK NUM])))) <=$(=Max([WEEK NUM]))"}>} DISTINCT COMBINE1)

Saro_2306 — Tue, 20 Oct 2020 15:42:49 GMT

No, its not working

Saro_2306 — Wed, 21 Oct 2020 10:07:36 GMT

Hi all,

Can we use like below.? is there any alternative for this.?

=sum({ < [WEEK NUM] = {">=$(=Yearstart(Max([WEEK NUM]))) <=$(=Max([WEEK NUM]))"}>} [PRODUCTION UNITS] / Count(DISTINCT COMBINE1) )

Brett_Bleess — Wed, 04 Nov 2020 16:36:18 GMT

Best I can offer is the following Design Blog post that may give you some ideas:

If you want to search further in that area, use the following link:

Regards,
Brett