Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

What is the Best way to Sort data for the following Scenario

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

Sort.PNG

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?

Thank you

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Sort both charts the same way by enabling numerical sort for the class dimension


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
MVP & Luminary
MVP & Luminary

Sort both charts the same way by enabling numerical sort for the class dimension


talk is cheap, supply exceeds demand

View solution in original post