Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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] ) /
WEEK NUM | Production Units | Working Days | Production / Days | YTD (it Shows) | YTD (I Need) |
1 | 118.1 | 2 | 59.05 | 59.05 | 59.05 |
2 | 304.87 | 5 | 60.974 | 60.42 | 120.024 |
3 | 309.59 | 5 | 61.918 | 61.05 | 181.942 |
4 | 223.23 | 4 | 55.8075 | 59.74 | 237.7495 |
5 | 237.46 | 5 | 47.492 | 56.82 | 285.2415 |
6 | 205.53 | 5 | 41.106 | 53.8 | 326.3475 |
Any one help me to rewrite formula. Thanks in advance.
@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
I Need results in Bar Chart. Weeknum is derived from Data using Week() formula in script.
Maybe try:
=sum({ < [WEEK NUM] = {">=$(=Week(Yearstart(Max([WEEK NUM])))) <=$(=Max([WEEK NUM]))"}>} [PRODUCTION UNITS] ) /
No, its not working
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) )
Best I can offer is the following Design Blog post that may give you some ideas:
https://community.qlik.com/t5/Qlik-Design-Blog/Year-over-Year-Comparisons/ba-p/1462927
If you want to search further in that area, use the following link:
https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog
Regards,
Brett