Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Partner
Partner

Expression for Sorting the data in straight table chart

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

1 Solution

Accepted Solutions
Partner
Partner

Expression for Sorting the data in straight table chart

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

4 Replies
yasus
New Contributor III

Expression for Sorting the data in straight table chart

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.

Not applicable

Expression for Sorting the data in straight table chart

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

Highlighted
Partner
Partner

Expression for Sorting the data in straight table chart

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.

Partner
Partner

Expression for Sorting the data in straight table chart

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