# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results 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 