# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for
Search instead for
Did you mean:  Specialist

## Using Dual Function with Class

I have the following calculated dimension class script:

=Left(Class(Amount, 10), FindOneOf(Class(Amount, 10), ' ',1))

& ' - ' &

(Num(Mid(Class(Amount,10), FindOneOf(Class(Amount, 10), ' ',4)))-1)

How do i incorporate the 'Dual Function' in the above script for me to be able to sort the calculated dimension as a value?

Regards.

Chris

1 Solution

Accepted Solutions  MVP

Perhaps this?

=Dual(Left(Class(Amount, 10), FindOneOf(Class(Amount, 10), ' ',1)) & ' - ' &

(Num(Mid(Class(Amount,10), FindOneOf(Class(Amount, 10), ' ',4)))-1),

Left(Class(Amount, 10), FindOneOf(Class(Amount, 10), ' ',1)) &

(Num(Mid(Class(Amount,10), FindOneOf(Class(Amount, 10), ' ',4)))-1)

)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
2 Replies  MVP

Perhaps this?

=Dual(Left(Class(Amount, 10), FindOneOf(Class(Amount, 10), ' ',1)) & ' - ' &

(Num(Mid(Class(Amount,10), FindOneOf(Class(Amount, 10), ' ',4)))-1),

Left(Class(Amount, 10), FindOneOf(Class(Amount, 10), ' ',1)) &

(Num(Mid(Class(Amount,10), FindOneOf(Class(Amount, 10), ' ',4)))-1)

)

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)  Specialist
Author

Thank you Anil 