Discussion board where members can get started with QlikView.
I have Large number of Credit Card Transaction. Approximately 50,000 Transaction in one month
Some spend less than 100, some spend 20,000
I want to show the number of users and total amount spend by the users in chart.
So I am creating two charts instead of one.
CHART 1 will have x dimesnion= Amount Spend, Y dimension = Count of Users
CHART 2 will have X dimension= Amount Spend, Y dimension = Sum of amount
For X Axis I am using a Class function to form a Range.
FInal chart is displayed as follows
My Issue is
I want user to compare top and bottom chart. I want to maintain consistent sort for X Axis. So that user can compare
example X axis should sort as follows 0-42, 42-84, 84-126, 126-169, 168-210
Similarly for Y axis
Basically I want sort based on X axis instead of Y Axis
1. How do I sort?
2. Is there any better way to show the chart?
Sort both charts the same way by enabling numerical sort for the class dimension
View solution in original post