topic Re: Qlikview - Barchart - Order Weeks Across Years in QlikView

Qlikview - Barchart - Order Weeks Across Years

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

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 — Fri, 05 Jan 2018 17:56:13 GMT

Are you going to have DESCENDING order?

martinpohl — Fri, 05 Jan 2018 17:58:21 GMT

create week as dual

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

so you have

201651

201652

201701

regards

MarcoWedel — Sun, 07 Jan 2018 23:33:10 GMT

What is your expected result?

v_nicolino — Mon, 08 Jan 2018 09:09:01 GMT

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

v_nicolino — Mon, 08 Jan 2018 09:12:30 GMT

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 — Mon, 08 Jan 2018 13:25:49 GMT

If possible please post sample test application