Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
raghavsurya
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
raghavsurya
Partner
Partner
Author

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

View solution in original post

4 Replies
yasus
Contributor III
Contributor III

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

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

syed_muzammil
Partner
Partner

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.

raghavsurya
Partner
Partner
Author

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

View solution in original post