Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Chanty4u
Esteemed Contributor III

Always last rows

     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?

Tags (2)
8 Replies

Re: Always last rows

Create a order table like

Order:

LOAD Month,

     Order

FROM

(ooxml, embedded labels, table is Sheet2);

Regards

Anand

Chanty4u
Esteemed Contributor III

Re: Always last rows

Hi Anand,

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

Re: Always last rows

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

Chanty4u
Esteemed Contributor III

Re: Always last rows

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

I generate one order table with order sequence for month field

 

MonthOrder
apr1
jul2
may3
jun4
mar5
dec6
jan7

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

Regards

Anand

Chanty4u
Esteemed Contributor III

Re: Always last rows

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

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

Chanty4u
Esteemed Contributor III

Re: Always last rows

Issue resolved Anand thanks