topic Re: Issue with sorting a straight table with multiple expression in QlikView

Issue with sorting a straight table with multiple expression

pavanpatha — Sat, 21 Mar 2015 15:27:28 GMT

Hi,

I have a straight table with 5 dimensions and 2 expressions. I am facing issues with sorting by expressions

Expression1 calculates Revenue in million or thousands ( eg: 5.0, 4.2, 4.1):

=if($(vCalc_Nsr)>1000000, DUAL(NUM($(vCalc_Nsr)*0.000001,'#,##0.0'),$(vCalc_Nsr)), DUAL(NUM($(vCalc_Nsr)*0.001,'#,##0'),$(vCalc_Nsr)))

Expression 2 indicates the text value as Million or thousand ( Million or thousand):

=if(top($(vCalc_Nsr))>1000000, 'million', 'thousand')

So overall the straight table values appears as 5.0 Million, 4.3 million, 3.0 thousand and so on.

Now, the problem is with sorting. I am able to get values in right sort order if expression 2 is disabled. but If I include expression 2, the sort order is getting disturbed. is there any way I can exclude expression 2 from sorting but should be shown in chart

P.S: I need to have two expressions mandatory because the client need a different font size for both. Expression1 for revenue with font size 10 and expression2 with font size 8.

Re: Issue with sorting a straight table with multiple expression

marcus_sommer — Sat, 21 Mar 2015 16:52:03 GMT

Have you tried it without sort-expression. In a straight-table you could sort by a double-click on the column-header from each column. Another possibility is to use only one expression-column and add for thousands/millions simply a "k" or "m" then to show this in full-length is no added value.

- Marcus

Re: Issue with sorting a straight table with multiple expression

maxgro — Sat, 21 Mar 2015 16:54:11 GMT

in sort tab uncheck all (sort by) for expression 2

or use dual in expression2 and sort number

=if(top($(vCalc_Nsr))>1000000, dual('million', $(vCalc_Nsr)), dual('thousand', $(vCalc_Nsr)))