Qlik Community

Ask a Question

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: 
chitemerere
Specialist
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
Anil_Babu_Samineni

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)

View solution in original post

2 Replies
Anil_Babu_Samineni

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)

View solution in original post

chitemerere
Specialist
Specialist
Author

Thank you Anil