Qlikview - Barchart - Order Weeks Across Years

[v_nicolino]

Hi,

I need to order a barchart week dimension across last 3 years. See attached image

The week number 1, with years 2017 and 2018, is always at left of chart,

Have you a solution?

[Anil_Babu_Samineni]

Are you going to have DESCENDING order?

[martinpohl]

create week as dual

dual (weekyear(date)*100+week(date),week(date)) as week

so you have

201651

201652

201701

regards

[MarcoWedel]

What is your expected result?

[v_nicolino]

The problem is not resolved. I'have sorted weeks and years as numeric value asc.

[v_nicolino]

i expect this:

Dimensions are:

week(DATE1) and year(DATE1)

The expression is:

=sum({1< DATE1 = {"<=$(=GetFieldSelections(DATE1))>=$(=dataMin)"}>+< DATE1 = {"<=$(=dataMaxAp1)>=$(=dataMinAp1)"}> } Pezzi/6)

[Anil_Babu_Samineni]

If possible please post sample test application