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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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,

Labels (1)
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?