topic Re: finding current week in QlikView

finding current week

ksk278074 — Sat, 16 Nov 2024 04:57:39 GMT

HI,

I am having the data like below

year/week sales

48.2017,10

49.2017,20

50.2017,30

10.2018,40

42.2018,50

based on above data how to get the max year week?

Thanks in advance.

Re: finding current week

tresB — Fri, 14 Dec 2018 10:11:35 GMT

Try like:

Firstsortedvalue([year/week], -(Subfield([year/week ], '.', 2)*100+ Subfield([year/week ], '.', 1))

Re: finding current week

ksk278074 — Fri, 14 Dec 2018 10:25:26 GMT

Thanks for the repy

HOw to get the sales for the max year week ?

for the aove exp i got max week now i want to sales for the max week

Thanks

Re: finding current week

rahulpawarb — Fri, 14 Dec 2018 10:25:37 GMT

May be this:

Data:
LOAD * INLINE [
year/week, sales
48.2017,10
49.2017,20
50.2017,30
10.2018,40
42.2018,50
];

MaxWeekYear:
LOAD Max(SubField([year/week], '.', 2)) AS MaxYear
Resident Data;
INNER JOIN (MaxWeekYear)
LOAD SubField([year/week], '.', 2) AS MaxYear,
Max(SubField([year/week], '.', 1)) AS MaxWeek
Resident Data
Group By SubField([year/week], '.', 2);

Re: finding current week

tresB — Fri, 14 Dec 2018 10:32:08 GMT

Firstsortedvalue(Aggr(Sum(sales), [year/week]), 
-(Subfield([year/week ], '.', 2)*100+ Subfield([year/week ], '.', 1))