topic Re: Set Analysis ,weekly format in QlikView

Set Analysis ,weekly format

VishalSingh18 — Sat, 16 Nov 2024 00:44:34 GMT

Hello

I am almost done with this dashboard and the only problem that exists is with filter of weekend dates , in filter ifi select a single week date the table for previous 4 weeks go null/blank if i select 2 weeks in filter it shows only max(week)-1, and so on

what I want to achieve is when i select any date in filter it should dynamically show the previous 4 weeks of data

in the below attached image i have filtered 4 week of data from max date and it shows only 3 weeks in table while it should also show the 4th previous week dynamically

Regards

Vishal Singh

Re: Set Analysis ,weekly format

HirisH_V7 — Mon, 04 May 2020 07:51:26 GMT

You should put on select trigger in such a way that, it should select last 4 weeks from what ever date you select.

For making it easy , we can have year and weeknumber field.

Re: Set Analysis ,weekly format

VishalSingh18 — Mon, 04 May 2020 09:30:18 GMT

this value is further divided in location, and weekend date are required as rows while location in columns

Re: Set Analysis ,weekly format

HirisH_V7 — Mon, 04 May 2020 12:18:40 GMT

As locations are synced with dates if i m not wrong, they will appear accordingly.

If we are missing anything in b/w. provide some sample data with u r result expected based on selection. so we can look forward to achieve that.

Re: Set Analysis ,weekly format

VishalSingh18 — Mon, 04 May 2020 13:53:30 GMT

I HAVE ATTAHED SAMPLE

AND ALSO REFER THE IMAGE ATTACHED IN START OF DISCUSSION

Re: Set Analysis ,weekly format

HirisH_V7 — Tue, 05 May 2020 08:27:25 GMT

Hi check this,

LOAD Location, Actual_RPP, Planned_RPP, Weekly_Rev_Actual, Weekly_Revenue_Planned, RPP_LB_Actual, RPP_LB_Planned, Plan_Date, 'W.E: ' & Weekend(Num#(Plan_Date,'DD-MM-YY')) as w.e.Date, Year(Num#(Date#(Plan_Date,'DD-MM-YY')))&Week(Num#(Date#(Plan_Date,'DD-MM-YY'))) as w.e.Date_Num, M_Date, week_No, floor, L FROM [Service(AutoRecovered).xlsx] (ooxml, embedded labels, table is RPP); UI Set analysis: Sum({1<w.e.Date_Num = {">=$(=Max(w.e.Date_Num-3)) <= $(=Max(w.e.Date_Num))"}>} Planned_RPP)

PFA

Re: Set Analysis ,weekly format

VishalSingh18 — Wed, 06 May 2020 05:44:44 GMT

unable to open the file

just help me with dimensions and expression

Thanks

Re: Set Analysis ,weekly format

HirisH_V7 — Thu, 07 May 2020 16:43:54 GMT

Dimensions are left field and top field, Expression is ..

=Sum({1<w.e.Date_Num = {">=$(=Max(w.e.Date_Num-3)) <= $(=Max(w.e.Date_Num))"}>} Planned_RPP)