# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
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

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

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