topic Re: Sorting of two expression in straight Table in QlikView

Sorting of two expression in straight Table

Anonymous — Mon, 13 Oct 2014 07:18:07 GMT

Dear Experts,

Can I sort two expressions at a same time in Straight Table?

If yes, then how?

Pls suggest.

Regards,

Balraj

Re: Sorting of two expression in straight Table

maxgro — Mon, 13 Oct 2014 07:30:28 GMT

if you want to sort by exp1 and exp2,

first click on exp2 label and then on exp1 label

Re: Sorting of two expression in straight Table

Mon, 13 Oct 2014 07:34:22 GMT

Hi,

You can use Promote/ Demote options in the expressions tab to sort your expressions (exp1/exp2)

Thanks

Charitha.

Re: Sorting of two expression in straight Table

Anonymous — Mon, 13 Oct 2014 07:34:50 GMT

Did not get you.....

Say, I am having two expression Expr1 and Expr2.

How I can do it in straight table??

In Sort tab, I can promote only one expression not all!!!

Re: Sorting of two expression in straight Table

maxgro — Mon, 13 Oct 2014 07:52:30 GMT

- in chart properties there is a sort tab

you can choose how to sort fields (using promote/demote) and sort by;

unchect "Allow Interective Sort";

in this way you can sort by 2, 3, .....n fields; the sort is static, not interactive (flag unchecked)

- or if you want to do an interective sort by n fields (field1, field2, ...., fieldn)

check "Allow interective Sort"

start sorting from the last field (fieldn) clicking on his label, then sort field-1 (click on label), then .... until field1

Re: Sorting of two expression in straight Table

Mon, 13 Oct 2014 07:57:00 GMT

can you elaborate what you are expecting exactly by an example.

Re: Sorting of two expression in straight Table

mdmukramali — Mon, 13 Oct 2014 08:07:24 GMT

Dear,

I think may be he is looking sorting should be like this??

Load * inline

[

Coutry,Sales,profit

India,2400,1000

US,2500,1200

AUS,2400,1200

SA,2600,800

NZ,2600,1200

]

;

sales are sorted and based on the sales he want to sort the Profit (1200 ,1000)

i don't know how to achieve this??

Re: Sorting of two expression in straight Table

Mon, 13 Oct 2014 08:32:07 GMT

Yes, as per my understanding one column (Sales) has been sorted manually, as well as Profit should be changed

as per the sales.

i think if we changed one column in the chart automatically others will reflect as per the user selection .

what do say ?

-Charitha.

Re: Sorting of two expression in straight Table

jagan — Mon, 13 Oct 2014 08:40:27 GMT

Hi,

You can set the priority of Sort, Promote Exp1 to the top and Exp2 to the second position. Now the charts initially sorts by Exp1, and then sorts by Exp2.

Hope this helps you.

Regards,

jagan.

Re: Sorting of two expression in straight Table

Mon, 13 Oct 2014 08:47:43 GMT

yes i agree with this.

Re: Sorting of two expression in straight Table

jagan — Tue, 14 Oct 2014 01:54:54 GMT

Hi,

Please close this thread if you got the answer.

Regards,

Jagan.

Re: Sorting of two expression in straight Table

ashfaq_haseeb — Tue, 14 Oct 2014 05:00:32 GMT

This is by design and you cannot change that.

at a time you can sort only one expression.

Regards

ASHFAQ