topic Re: Sort by with an if clause in App Development

Sort by with an if clause

KerstinP — Fri, 18 Nov 2022 11:59:27 GMT

Hello,

I have a dimension (Product) and a value (Orders). I created a variable to switch between the value of the orders itself and the amount of the orders.

=if((vDefaultAmount)='Value',
Sum(Orders)/1000,
Sum(Amount_Orders))

How can I sort the data. I always want to see the sorting by the value of the orders - even my variable is shwoing Amount.

And how can I change the format. My values should look like 0'000 and my amount like 0.000?

Thanks for your help!

BR Kerstin

Re: Sort by with an if clause

brunobertels — Fri, 18 Nov 2022 14:00:52 GMT

may be to format number

replace(num(Sum(Orders),'#,###'),',',chr(39))

=if((vDefaultAmount)='Value',
num(Sum(Orders),'#,###') ,
replace(num(Sum(Amount_Orders),'#,###'),',',chr(39))

)

for sorting order

Use the rank function

rank(Sum(Orders))

Re: Sort by with an if clause

KerstinP — Mon, 21 Nov 2022 09:39:21 GMT

thanks, for your response!

Qlik no longer displays quantity. I don't know why.

And the sorting does not work. It is still the old wrong order. Is it correct to put it into the tab "sorting"?

BR, Kerstin