topic Re: 53 Week problem in QlikView

53 Week problem

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

Hi all,

I have 2 year

2015 and 2016

For 2015 i have 53 weeks,in 53 week has four days from 2015 and three from 2016

2016 has 23 weeks of data

When I use this formula

=num( Sum({<Flag_ = {1},Year_UP = {$(=Max(Year_UP))},Week_UP = {$(=Max(Week_UP))}>}Orders )

,0.00)

Its calculating 53 week as maxweek but i want 23 week of 2016 should be selected.

Suggest me some ideas

Regards,

Joshua.

Kushal_Chawda — Fri, 03 Jun 2016 08:08:11 GMT

I think you need to redefine your week

ajsjoshua — Fri, 03 Jun 2016 09:02:38 GMT

Hi kushal,

I tried that also but still its not rectified

Regards,

Joshua.

kaushiknsolanki — Fri, 03 Jun 2016 09:26:41 GMT

Try this,

=num( Sum({<Flag_ = {1},Year_UP = {$(=Max(Year_UP))},Week_UP = {$(=Max({<Year_UP = {$(=Max(Year_UP))}>}Week_UP))}>}Orders )

,0.00)

Regards,

Kaushik Solanki

ajsjoshua — Fri, 03 Jun 2016 10:06:19 GMT

Hi Kaushik,

Thanks for ur reply

Not working bro same result.

kaushiknsolanki — Fri, 03 Jun 2016 10:09:32 GMT

Try this,

Use the quotes and check.

=num( Sum({<Flag_ = {1},Year_UP = {'$(=Max(Year_UP))'},Week_UP = {'$(=Max({<Year_UP = {'$(=Max(Year_UP))'}>}Week_UP))'}>}Orders )

,0.00)

If this doesnt work please share the sample data which replicates your problem.

Regards,

Kaushik Solanki