Can we sort data using 2 qualifiers

[siddharthsoam]

I want to sort data by one expression, then again only for top5 accounts sort them by another expression. Can I identify top 5 rankings after sort in Qliksense.

[shraddha_g · Accepted solution]

Yes.

Limit Dimension value to Top 5 from Dimension Section of Chart.

There You will get a dropdown for Data Limitation.

Choose Fixed Number from Dropdown and put 5 in Text Box.

Here it will take top 5 according to 1st Measure in Measure Section.

Then In Sorting Option.

You can Sort that Dimension by Using option as Sort by Expression.

There put 2nd measure and apply ascending or descending as required.

It might help.

[siddharthsoam]

I want first to sort whole the data from expression 1 and then only top 5 rankings with expression 2, the rest of the data should be sorted by expression 1 only.

[shraddha_g]

Can you share scenario with sample data?

[siddharthsoam]

Hi Shraddha,

PFA base data and app file,

I want to sort my CDG by service revenue, and for the top 3 ranks I want to sort them by "bought out revenue" and the rest of the CDG would be sorted by service revenue only.

[shraddha_g]

Do you want to display all CDG and not only Top 3?

[shraddha_g]

Check this app.

But I don't think this is what you want