topic Re: Always last rows in QlikView

Always last rows

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

Hi all,

i have strange issue.

i have data like below attached and

the result in pivot table ....... should be always 5,6th record should go to bottom lines.

PFA. sample excel with input and output.

in my data dec,jan rows should come bottom

Can anyone help me on this?

Re: Always last rows

its_anandrjs — Mon, 28 Nov 2016 18:14:45 GMT

Create a order table like

Order:

LOAD Month,

Order

FROM

(ooxml, embedded labels, table is Sheet2);

Regards

Anand

Re: Always last rows

Chanty4u — Mon, 28 Nov 2016 18:17:44 GMT

Hi Anand,

I didn't get your input ? could you please explain?

Re: Always last rows

its_anandrjs — Mon, 28 Nov 2016 18:24:28 GMT

Load your data this ways

Data:

LOAD Month,

Region,

Sales,

Year

FROM

(ooxml, embedded labels, table is Sheet1);

Order:

LOAD Month,

Order

FROM

(ooxml, embedded labels, table is Sheet2);

Note:- But what about the May that is also come last in your out put for more please see the attached qvw or please explain more.

Regards

Anand

Re: Always last rows

Chanty4u — Mon, 28 Nov 2016 18:28:21 GMT

Hi anand,

Thanks for your input. But what is Order? can you explain this? what it will do? how the output delivered?

can you explain?

Re: Always last rows

its_anandrjs — Mon, 28 Nov 2016 18:35:11 GMT

I generate one order table with order sequence for month field

Month	Order
apr	1
jul	2
may	3
jun	4
mar	5
dec	6
jan	7

Note:- Also how you decide the sequence of this Month table let me know.

Regards

Anand

Re: Always last rows

Chanty4u — Mon, 28 Nov 2016 18:37:20 GMT

thanks Anand. that we need to check currently user need to see the data 5,6 th record should be in last row.

will update you once i got clear info.

Good night.

Re: Always last rows

its_anandrjs — Mon, 28 Nov 2016 18:43:59 GMT

Thanks Ok,

One way also if you need only the dec and jan should always be last two rows then try to load sequence table into the data model and connect it with the Month field and in front end with chart do make some changes on the sorting order.

SortOrder:

LOAD * Inline

[

Month,OrderSeq

feb,1

mar,2

apr,3

may,4

jun,5

jul,6

aug,7

sep,8

oct,9

nov,10

dec,11

jan,12

];

Regards

Anand

Re: Always last rows

Chanty4u — Tue, 29 Nov 2016 08:55:31 GMT

Issue resolved Anand thanks