topic Weekly and YTD charts on the same view. in QlikView

Weekly and YTD charts on the same view.

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

Hello,

I need to display a weekly sales and a year to date charts on the same view. In the weekly sales chart I always display one week at a time, but the ytd chart should always show the ytd sales regardless of the chosen week. Any ideas on how to implement this? thanks.

Re: Weekly and YTD charts on the same view.

Mon, 31 Oct 2016 23:12:55 GMT

We can use set analysis or by using conditional flags

sum({1<Year={vCurrentYear}>} [ytd sales])

1 in above expression will use full set of data disregarding user selections.

sum ([ytd sales]* _CYTD_Flag)

For above expression to work, you need to have flags on date dimension created during document load. In our case _CYTD_Flag refers to all days in current year until today.

Re: Weekly and YTD charts on the same view.

Anonymous — Wed, 02 Nov 2016 11:39:25 GMT

Thank you. I did some changes using your guidelines and it works