topic Expression for Sorting the data in straight table chart in QlikView

Expression for Sorting the data in straight table chart

raghavsurya — Mon, 23 May 2011 13:40:55 GMT

Hi All,

We have defined a variable for product and calculating the what-if scenarios only for the product selected in the input box linked to the variable. The straight table chart contains around 13k products and its sales details. The increase/decrease in sales applies to only the product selected in input box and its getting changed as per expectations.

But we need the products selected in the inputbox to be displayed first in the table. Can you please suggest how to do it.

Regards,

Raghav

Expression for Sorting the data in straight table chart

yasus — Mon, 23 May 2011 14:01:20 GMT

Hi Rahav,

you can use the sort ascending/descenting function with reference to your increase/decrease expression in the properties of your chart.

The results will be either at the top or at the bottom of the table afterwards.

Expression for Sorting the data in straight table chart

Mon, 23 May 2011 14:54:29 GMT

I dont know whether I got you or not if I'm wrong just correct me and help me to understand the problem ...

Try to sort with the expression in asc/desc format and unselect the alphabetical order to sort

Go to chart properties and go to sort tab there you can change it

Thanks

Brad

Expression for Sorting the data in straight table chart

syed_muzammil — Mon, 23 May 2011 15:21:04 GMT

Hi,

In the Properties->Sort->By Expression , write the following expression.

If(Product=Variable,1,2).

It will automatically show the Variable product selected as the first product in the table.

Expression for Sorting the data in straight table chart

raghavsurya — Tue, 24 May 2011 04:46:22 GMT

Thanks Syed.... your suggestion helpmed us a lot