topic Re: rename the class function value in QlikView

rename the class function value

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

Hi all I am using a Class function for Price Bucket :

Dual(Replace(Class(KeepChar(SubField(SearchVertical,':',2),'0123456789'),2500000),'<= x <', 'To'),

Class(KeepChar(SubField(SearchVertical,':',2),'0123456789'),2500000))

So i am Getting a value like

0 to 2500000

25000000 to 5000000

But i want to show figure like

o to 2500K

2500K To 5000K

Kinldly help me achieve this.

i have a attached a image of bar as well'

sunny_talwar — Tue, 26 Apr 2016 11:16:28 GMT

May be this:

Dual(

SubField(Class(KeepChar(SubField(SearchVertical,':',2),'0123456789'),2500000),'<= x <', 1)/1000 & 'K To ' &

SubField(Class(KeepChar(SubField(SearchVertical,':',2),'0123456789'),2500000),'<= x <', 2)/1000 & 'K',

Class(KeepChar(SubField(SearchVertical,':',2),'0123456789'),2500000))

mightyqlikers — Tue, 26 Apr 2016 11:17:35 GMT

use

KeepChar(SubField(SearchVertical,':',2),'0123456789')

in the back end and create a field divide by 1000

and use that in front end using class function.

$@M

brijeshvma — Tue, 26 Apr 2016 11:34:35 GMT

Thankks Sunny

swuehl — Tue, 26 Apr 2016 11:34:58 GMT

Or maybe (since there is not much benefit to use the class function then in your case):

Dual(

Floor(KeepChar(SubField(SearchVertical,':',2),'0123456789'),2500000)/1000 & 'K To ' &

Ceil( KeepChar(SubField(SearchVertical,':',2),'0123456789'),2500000)/1000 & 'K',

Floor(KeepChar(SubField(SearchVertical,':',2),'0123456789'),2500000)

)