topic Re: Sorting on Column in straight table in QlikView

Sorting on Column in straight table

Anonymous — Tue, 16 Apr 2013 19:52:44 GMT

Hi All,

We have a straight table and has multiple columns.

1. Sales value

Expression:

= if($(sales)>=1000000000 ,NUM($(sales)/1000000000,'$#,###.0B'),

if($(sales)<1000000000 and $(sales)>=1000000, NUM($(sales)/1000000,'$#,###.0MM'),

NUM($(sales)/1000,'$#,###.0K'))

)

2. Other columns

We kept sorting on the sales column.This works fine when we have all thee vlaues in one group either B or MM or K. when mixed group comes up we this sorting does not work. Is there any way I can sort all in the raw sales data and use that for sorting instead of display column?.

Sales	Previous Day Change	Net Change	Actual Sales
$100 K	1%	0.25%	100000
$98 B	2%	0.25%	98000000000
$3 M	3%	0.25%	3000000

Re: Sorting on Column in straight table

Tue, 16 Apr 2013 19:59:32 GMT

Yes. You can sort by expression.

Just set expression = sum(sales).

Also, Why the if/then with the num function? On the Number tab there is a space for Symbol, Thousand Symbol, Million Symbol, Billion Symbol - you can use these and it will take care of the formatting for you without having to break it up.

Re: Sorting on Column in straight table

Anonymous — Tue, 16 Apr 2013 20:08:11 GMT

Sort column expression is disabled. Is there any way I can enable it?.

Re: Sorting on Column in straight table

Tue, 16 Apr 2013 20:11:07 GMT

Hmm. I don't know! I haven't seen that disabled before.

User Preferences - Design - Default Styling Mode = Advanced, maybe?

Or Document Properties - General - Styling Mode = Advanced?