Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

siddharthsoam
Contributor

Can we sort data using 2 qualifiers

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.

1 Solution

Accepted Solutions
shraddha_g
Honored Contributor III

Re: Can we sort data using 2 qualifiers

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.

6 Replies
shraddha_g
Honored Contributor III

Re: Can we sort data using 2 qualifiers

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
Contributor

Re: Can we sort data using 2 qualifiers

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
Honored Contributor III

Re: Can we sort data using 2 qualifiers

Can you share scenario with sample data?

siddharthsoam
Contributor

Re: Can we sort data using 2 qualifiers

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
Honored Contributor III

Re: Can we sort data using 2 qualifiers

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

shraddha_g
Honored Contributor III

Re: Can we sort data using 2 qualifiers

Check this app.

But I don't think this is what you want

Community Browser