Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

choice of dimension to be displayed on x axis for chart

I am working on a chart

dimension1dimension2Expression1
AJan1010
AFeb1012
AMar1014
AApr1010
AMay1012
AJun1014
BJan1021
BFeb109
BMar1016
BApr1010
BMay1012
BJun1014

My expression is dependent on the order by which dimension1 & dimension2 are displayed.

Keeping above table, column orders as shown above, when I create a graph, on x axis I get dimension1 (values - A,B)

& dimension2 on y axis.

I need to display dimension2 on x axis & dimension1 on y axis.

It should display 2 series lines for A & B.

7 Replies
Not applicable
Author

Create a line chart.

dimension2 is the first dimension; dimension1 the second.

Alex

Not applicable
Author

Thanks Alex for your reply.

But this does not help me.

I can not change the sequence of dimensions, because if I do, the values in the expression column change to invalid values.

It is becuase of the expression has used cumulative aadition.

Attaching herewith sample data which may help explain my issue.

Your help further will be much appreciatiated. Thanks again.

Not applicable
Author

Thanks Alex.

Not applicable
Author

Anybody who knows how to do this? Please reply.

neetu_singh
Partner - Creator III
Partner - Creator III

Can you send me the expression that you are using for calculation. Because as per my knowledge datavalue can not be change if we promote or demote any dimension.

Not applicable
Author

The expression is too complex and uses many other fields from database.

But to generate cumulative attrition, we are using above() function, which makes it sequence dependent.

above() function copies value from the cell just above current cell & works with it.

i think we need to find alternative to above() function so as to make whole data independent of sequence.

Not applicable
Author

The expression is too complex and uses many other fields from database.

But to generate cumulative attrition, we are using above() function, which makes it sequence dependent.

above() function copies value from the cell just above current cell & works with it.

i think we need to find alternative to above() function so as to make whole data independent of sequence.