Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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.

Tags (1)
7 Replies
Not applicable

choice of dimension to be displayed on x axis for chart

Create a line chart.

dimension2 is the first dimension; dimension1 the second.

Alex

Not applicable

choice of dimension to be displayed on x axis for chart

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

choice of dimension to be displayed on x axis for chart

Thanks Alex.

Not applicable

choice of dimension to be displayed on x axis for chart

Anybody who knows how to do this? Please reply.

neetu_singh
Contributor III

choice of dimension to be displayed on x axis for chart

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

choice of dimension to be displayed on x axis for chart

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

choice of dimension to be displayed on x axis for chart

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.