topic Re: YTD Calculation for Weekly Dashboard in QlikView

YTD Calculation for Weekly Dashboard

ishanbansal1204 — Sat, 10 Dec 2016 09:19:46 GMT

Hi Experts,

I have a situation where

Data set has been attached ***

Week and year are the filters

1st dashboard

gender is the dimension and count(age_group) is the measure

Now, when i select week and year from the filter i get details of that week.

But now as per the requirement i want the YTD values for the same

so if i am selecting week 6 and year 2016

i should get the values from week count(week1 till week6) of 2016 ( Basically the YTD)

Please suggest.

sunny_talwar — Sat, 10 Dec 2016 12:24:07 GMT

Here are two expressions you can use

1) Count({<week = {"<=$(=Max(week))"}>} age_group)

2) Count({<Date = {">=$(=YearStart(Max(Date)))<=$(=Max(Date))"}, week, year>} age_group)

ishanbansal1204 — Mon, 12 Dec 2016 03:42:43 GMT

Hi Sunny,

In this case this will work for Week, but we need to add year parameter as well rite?

sunny_talwar — Mon, 12 Dec 2016 12:15:10 GMT

1st expression will most likely need it, but the second expression should be fine.