Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Sorting data based on 2 expressions (in a chart)

Hi all,

I currently have a set of data like this:

ValueJournal IDUser
1001isaac
2004isaac
2503isaac
502joseph
105joseph
138luke
129mary
5010miranda

My aim is to create a chart with:

1 dimension (User)

and 2 expressions (sum of value) and count(distinct Journal ID) for each user.

I manage to create a chart just fine ( an example of this is attached) . However i'm having difficulty sorting the cart, I would like to sort the chart based on High value and low volume.

Does anyone know If I can achieve this?

Thanks

Tags (2)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Sorting data based on 2 expressions (in a chart)

ok

kindly find the attachment.

View solution in original post

8 Replies
Highlighted
Partner
Partner

Re: Sorting data based on 2 expressions (in a chart)

hi

can you be more specific , how can you combine the two measures

my only thought is you can use rank for both measures and take sort according to the sum of the two ranks

for example rank(sum(value))+rank(-count(distinct Journal ID) )

this way you get low ranks if you have high value low volume

Highlighted
Partner
Partner

Re: Sorting data based on 2 expressions (in a chart)

Hi

do you want some thing like this

Capture1.PNG

Highlighted

Re: Sorting data based on 2 expressions (in a chart)

what is your expected sorted value????

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
Creator
Creator

Re: Sorting data based on 2 expressions (in a chart)

Hi Vishweshwari,

Yes please that's exactly what I am trying to achieve

Highlighted

Re: Sorting data based on 2 expressions (in a chart)

In that case you can sort it like property > sort > sort by Y-Value - > Descending.

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Highlighted
Partner
Partner

Re: Sorting data based on 2 expressions (in a chart)

ok

kindly find the attachment.

View solution in original post

Highlighted

Re: Sorting data based on 2 expressions (in a chart)

May be this:

Sum(Aggr(Count(Distinct JournalID),User,Value))

Highlighted
Creator
Creator

Re: Sorting data based on 2 expressions (in a chart)

Thank you Vishweshwari,

Did you just sort by state and expression sum(value)?

I can see how it works perfectly on the dashboard you  kindly provided but doesn't work on my dashboard. I don't know if i'm missing something or if I need to re-load my data and force the Journal ID to be numeric

Thanks,

Isaac