topic Re: Dual function in QlikView

Dual function

gayathridevi24 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Dual function

vishsaggi — Fri, 24 Aug 2018 16:29:54 GMT

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

Re: Dual function

gayathridevi24 — Mon, 27 Aug 2018 05:50:37 GMT

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.

Re: Dual function

Anil_Babu_Samineni — Mon, 27 Aug 2018 07:04:59 GMT

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"

Re: Dual function

raman_rastogi — Mon, 27 Aug 2018 07:43:11 GMT

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