Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
akpofureenughwu
Creator III
Creator III

Data sorting in funnel extension (qliksense)

Hello guys... I'm using a funnel extension for data visualization

I'm trying to sort the visual from the least value ( the apex) to  the the highest value ( the base)

here are my lines of script:

dimension: =ValueList('UA','UC','RTA', 'CD','DO', 'FAT','FI', 'LTI', 'MTC', 'NM', 'OS' )

measure:

Pick(Match(ValueList('UA','UC','RTA', 'CD','DO', 'FAT','FI', 'LTI', 'MTC', 'NM', 'OS' ),'UA','UC','RTA', 'CD','DO', 'FAT','FI', 'LTI', 'MTC', 'NM', 'OS'),Sum({<Key={'UA'}>}Value),Sum({<Key={'UC'}>}Value),Sum({<Key={'RTA'}>}Value),Sum({<Key={'CD'}>}Value),Sum({<Key={'DO'}>}Value),Sum({<Key={'FAT'}>}Value), Sum({<Key={'FI'}>}Value),Sum({<Key={'LTI'}>}Value), Sum({<Key={'MTC'}>}Value), Sum({<Key={'NM'}>}Value), Sum({<Key={'OS'}>}Value))

I tried sorting by expression: no change

Regards

0 Replies