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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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?