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: 
isciberras
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

1 Solution

Accepted Solutions
vishweshwarisun
Partner - Creator
Partner - Creator

ok

kindly find the attachment.

View solution in original post

8 Replies
lironbaram
Partner - Master III
Partner - Master III

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

vishweshwarisun
Partner - Creator
Partner - Creator

Hi

do you want some thing like this

Capture1.PNG

PrashantSangle

what is your expected sorted value????

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
isciberras
Creator
Creator
Author

Hi Vishweshwari,

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

PrashantSangle

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.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
vishweshwarisun
Partner - Creator
Partner - Creator

ok

kindly find the attachment.

balabhaskarqlik

May be this:

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

isciberras
Creator
Creator
Author

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