topic text object complex logic in QlikView

text object complex logic

Tue, 29 Jul 2014 04:40:08 GMT

I need the followig representaion in Text object dynamically if user selects the number the result should be i 3.1bn, 4.2m .......

*the number 3,055,123,456 should be displayed as ("3.1Bn")

*the number 4,160,023 should be displayed as ("4.2M")

*The number 45,801 should be displayed as ("46k")

do respond me

tresB — Tue, 29 Jul 2014 05:00:08 GMT

=If(number/1000000000>1, Round(number/1000000000,0.1)&'Bn',

If(number/1000000>1, Round(number/1000000,0.1)&'M',

If(number/1000>1, Round(number/1000,0.1)&'K', number)))

PFA

sujeetsingh — Tue, 29 Jul 2014 05:03:54 GMT

You can use nested if statement as

Let the selecting field be Field1 and there is another Field2

=if(GetFieldSelections(Field1)='',then )