Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Join us March 10th, 7 ways modern analytics can help you take smarter action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
MoxieMeister
Contributor II
Contributor II

Sorting two level column

Hi all,

I have some problems with sorting in the column name levels.

My try is:

!!!.png

 

 But necessary make like this:

11.png

Cannot swap columns level.

 Is it possible?

Thanks.

 

 

Labels (3)
3 Replies
Anismohamed32
Partner
Partner

Hi ,

You can sort the column at your own wish , by having if condition in the sorting tab.

1. click the sort option
2.write if condition by selecting the option set by expression.
3. if condition example :
=if(group='M27',1,
if(group='Axis',2,
if(group='Black',3,
if(group='GSC',4,
if(group='T3',5,
if(group='TDM,6,7)

MoxieMeister
Contributor II
Contributor II

Hi,

The basic idea of sorting is to ignore the sorting of the first header.

In this case, test data is presented. In the original, data is added dynamically.

Accordingly, this 'If' does not universal approach.

Thanks.

Anil_Babu_Samineni

Try this as a Sort by expression

Match(Group, 'M27','Axis','Black','T3','TDM')

If not, Create Mapping field in the script with some serial no to form same as that field

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)