topic Re: Sorting Week No in chart in QlikView

Sorting Week No in chart

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

Hi I am displaying weekly trade amount in line chart but unable to sort the week according to the dates.

for example

week 52 for yr 2016 should appear before the week 1 of yr 2017

Can ome one help me out with this

table:

Week_No	SURV_Date	Trade Amt
1	02 01 17	0.8
4	23 01 17	0.6
5	30 01 17	0.33
52	26 12 16	3.2
6	06 02 17	1.4
8	20 02 17	3.8
9	27 02 17	2.2

Re: Sorting Week No in chart

sunny_talwar — Wed, 29 Mar 2017 09:31:39 GMT

May be use a calculated dimension

Dual(Week_No, WeekStart(SURV_Date))

Re: Sorting Week No in chart

dsharmaqv — Wed, 29 Mar 2017 12:18:38 GMT

Thanks Sunny

Also can you please help me in getting the latest week sales amt

in above case week no 9 has sales amt 2.2

Re: Sorting Week No in chart

sunny_talwar — Wed, 29 Mar 2017 12:27:59 GMT

May just this

Sum({<SURV_Date = {"=$(Max(SURV_Date))"}>}[Trade Amt])

Re: Sorting Week No in chart

dsharmaqv — Wed, 29 Mar 2017 12:33:17 GMT

I am trying to display latest value in text object but with above expression I am getting 0

Re: Sorting Week No in chart

sunny_talwar — Wed, 29 Mar 2017 12:36:02 GMT

My bad, I misplaced an equal sign

Sum({<SURV_Date = {"$(=Max(SURV_Date))"}>}[Trade Amt])

Re: Sorting Week No in chart

dsharmaqv — Wed, 29 Mar 2017 12:45:47 GMT

expression is summing up all the values

returning

12.33

can you please post the app.

Re: Sorting Week No in chart

sunny_talwar — Wed, 29 Mar 2017 12:50:36 GMT

I create a new field to do this

Table:

LOAD *,

Num(Date#(SURV_Date, 'DD MM YY')) as DateNum;

LOAD * INLINE [

Week_No, SURV_Date, Trade Amt

1, 02 01 17, 0.8

4, 23 01 17, 0.6

5, 30 01 17, 0.33

52, 26 12 16, 3.2

6, 06 02 17, 1.4

8, 20 02 17, 3.8

9, 27 02 17, 2.2

];