Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Register by January 31 for $300 off your Qlik Connect pass: Register Now!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-05-02 03:28 PM

Waterfall chart

Hi,

I am trying to build a waterall chart.  However, I have not defined any dimensions and my columns are derived from my expressions.  How do I sort individual columns?

Is it possible to sort one column while keeping another's position fixed, i.e., if I have column A B and C, I want to sort columns B and C according to Sales but want to keep the position of A fixed, will it be possible given the current set up?

971 Views
0 Likes
1 Reply
Not applicable
‎2012-05-02 03:47 PM
Author

Expressions are sorted by the location in the expression tab of the properties window. Top will display first etc.

You would have to tell it to change the actual expression based on value like:

if (B>C,B,C)

if (B>C,C,B)

Where B and C are expressions. Then if B is greater it will change the expression used

345 Views
0 Likes