topic Re: ordre in pivot table in QlikView

ordre in pivot table

Tue, 01 Mar 2016 10:52:32 GMT

Hi,

i want to show data in a specific order, so that in my inlines i add a order column for exemple:

LOAD * INLINE [

CODE_CATEGORIE41, COMPTE EXPLOITATION, ORDRE_CE

71100, Ventes de Marchandises en état, 1

71101, Ventes de Marchandises en état, 1

71102, Ventes , 2

71103, Ventes , 2

71104, CA, 3

71105, CA, 3

];

and in my sort expression i try this:

=Match(ORDRE_CE,'1','2','3)

and this

=ORDRE_CE

but in both situations it inverse the two last order, it gives me

Ventes de Marchandises en état

Ventes

can anybody tell me why i have this issue

thank you

Re: ordre in pivot table

Chanty4u — Tue, 01 Mar 2016 11:09:16 GMT

LOAD * INLINE [

CODE_CATEGORIE41, COMPTE EXPLOITATION, ORDRE_CE

71100, Ventes de Marchandises en état, 1

71101, Ventes de Marchandises en état, 1

71102, Ventes , 2

71103, Ventes , 2

71104, CA, 3

71105, CA, 3

];

where ORDRE_CE ascending;

Re: ordre in pivot table

sunny_talwar — Tue, 01 Mar 2016 11:10:16 GMT

Is it doing this after you make a selection or even without selection? If it happens only after making a selection, try this;

=Only({1} ORDRE_CE)

Re: ordre in pivot table

Tue, 01 Mar 2016 11:16:03 GMT

thank you for answer, it happens without making selection.

i tried Only({1} ORDRE_CE) and it works could tell me what only and {1} means

Re: ordre in pivot table

MayilVahanan — Tue, 01 Mar 2016 11:21:04 GMT

{1} - Ignore all the selection

ORDRE_CE and only(ORDRE_CE) both are same.

we can use set analysis Only() function, not by field name alone.

So, Only({1}ORDRE_CE) avoid selection made by user. And display the order properly

Re: ordre in pivot table

sunny_talwar — Tue, 01 Mar 2016 11:30:58 GMT

MAYIL got before me, but yes the idea is to tell the sort to ignore any selections because it may filter out some of the options based on certain selections you make.

Re: ordre in pivot table

Tue, 01 Mar 2016 12:05:42 GMT

thank you all for your answres