WTD in qliksense table

Aspiring_Developer — Mon, 18 Jul 2022 14:07:57 GMT

Hello All,

I am trying to calculate WTD where my week start date should correspond to Sunday and week end date should be Monday.

In the script , I have changed below:-

SET FirstWeekDay=6; // changed from 0 to 1 Vb test
SET BrokenWeeks=0;

Now I have proper week start and week end dates as follow:-

Here week start dates are for Sunday's and week end is Monday.

Now , what I want to show is a table with dimension as Date (only for Saturday i.e date corresponding to Saturday only ) and in measure, cumulative sum of entire week. (WTD- sum of numbers starting from sunday and ending at Monday). I tried using below expression but it did not worked:-

Sum({< Date_key={">=$(=Num(WeekStart(Max(Date_key))))<=$(=Num(WeekStart(Max(Date_key))))"}>} total_logged)

Can anyone please help ?

Just to add, I have other dates as well in my data model and in few charts I am displaying only Saturday dates as dimension in the visual. So, when I changed the value of set Firstdayofweek from 0 to 6 , it disturbed the other dates in the data model.

Please help ?I am stuck 😞

@OmarBenSalem @tresB

@hic @mvpkruger @bbruno @sunny_talwar @Kushagra

Re: WTD in qliksense table

Aspiring_Developer — Mon, 18 Jul 2022 14:04:47 GMT

Can anyone please help ? Can we achieve it using peek and previous functions and create flags at backend end ?

topic Re: WTD in qliksense table in App Development

WTD in qliksense table

Re: WTD in qliksense table