Skip to main content
Announcements
See why Qlik was named a Leader in the 2024 Gartner® Magic Quadrant™ for Data Integration Tools for the ninth year in a row: Get the report
cancel
Showing results for 
Search instead for 
Did you mean: 
antonybi
Creator
Creator

pls suggest

Hi All,

I've a filter box(rolling month) like below

snap.JPG

I want this in sorting order but unfortunately this extension has no sort option.

can someone help me out in this.

Thanks,

3 Replies
ValeriyaBartosh
Partner - Contributor III
Partner - Contributor III

Hello, try to use DUAL()

Screenshot_3.png

manoranjan_d
Specialist
Specialist

in case if you more records for the rolling periodyear

create rowno() for your table and then use the dual(roolingperiodstring,rwono)

Peter_Cammaert
Partner - Champion III
Partner - Champion III

If you consider just the 22 values from your screenshot (already with many overlaps and conflicts), then how do you want them to be sorted? Can you post a list of those 22 values, but now sorted?