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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
gayathridevi24
Contributor III
Contributor III

Dual function

Hi All,

I am using the dual function with class function for sorting but it is not sorting.

It is giving the same order. I have used the formula (=dual(replace(class([order total],1000),'<= x <','-'),class([order total],1000)).)

Please find the attached file.

Thanks and Regards,

Gayathri Devi

4 Replies
vishsaggi
Champion III
Champion III

Are you looking for this? If yes, then follow highlighted.

Capture.PNG

gayathridevi24
Contributor III
Contributor III
Author

Thank you for the support.

I am trying to know the dual function behavior. Dual function is used for sorting purposes.

But in my case it is not sorting. Can you please provide the solution for the above query.

Anil_Babu_Samineni

No body won't say Dual is used only for Sorting. It can capture string + data points together over mouse. Can you check the same. For your case just do Sort by Expression using "order total"

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
raman_rastogi
Partner - Creator III
Partner - Creator III

Hi

See this for Dual function

How to use- Dual()

Sorting with class function

The class function returns values with both a text format and a numeric value. So the results of the class function can be sorted by Numeric Value.


For More

Class Sorting Order