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: 
Anonymous
Not applicable

Sort Expression for Total of Dimension Limits

Hi everyone, I am confused about the expression in sort for total of dimension limits. I want to sort the Total column in the following attached file to TOP 1 with this expression below :

if(MA_DVIQLY='Total',1)


but Its not worked. Everybody can help me to give me the best solution, please ?

1 Solution

Accepted Solutions
sunny_talwar

One option is to create an inline table:

LOAD * Inline [

Dim

1

2

];

And change your dimension to this:

=Pick(Dim, 'TOTAL', MA_DVIQLY)

Expression:

Pick(Dim, Count(TOTAL SLKHANG_MDIEN_TT), Count(SLKHANG_MDIEN_TT))

Capture.PNG

View solution in original post

3 Replies
settu_periasamy
Master III
Master III

May be like attached?

sunny_talwar

One option is to create an inline table:

LOAD * Inline [

Dim

1

2

];

And change your dimension to this:

=Pick(Dim, 'TOTAL', MA_DVIQLY)

Expression:

Pick(Dim, Count(TOTAL SLKHANG_MDIEN_TT), Count(SLKHANG_MDIEN_TT))

Capture.PNG

Anonymous
Not applicable
Author

Thanks sunindia‌ very much. Your solution is absolute correct