number formating using set analysis

[#1]

hi

i am creating a pivot table in which i am having 5 rows and 4 columns.

in the pivot table i have to bring %sign in some rows. how can i achieve that???

my situation is like dis

[#2]

plz tell me the logic.. i am using personal edition of qlikview so cant opn qvw....

[#3]

Hi,

It can be done in two ways,

first you can use expression as 

if(dimension='rate',num( p1,'#0 ')&'%',num( p1,'#0'))

or

if(dimension='rate',num( p1/100,'#0 %'),num( p1,'#0'))

..

Ashutosh

[#4]

im using this expression

num#((sum({$cola={1},col2={'J'},col3={'K'}>}Interest)/(sum({$cola={1},col2={'J'},col3={'K'},LTAC_IND={'*'}-{'Y'}>}Ip))*100),'##%')

still its nt wrking wat is the error in it???

[#5]

Hi,

Don't use NUM# rather use NUM

Num# is to process input while Num is to show output.

...

Ashutosh

[#6]

still its nt wrking...plz help me in sorting out this prblm....

num((sum({$cola={1},col2={'J'},col3={'K'}>}Interest)/(sum({$cola={1},col2={'J'},col3={'K'},LTAC_IND={'*'}-{'Y'}>}Ip))*100),'##%')

still its nt wrking...

[#7]

Hi,

The problem seems with your expression which you have written.

Does this expression gives you value?

Can you first try it in a text object?

Just try it in a text object first, if it gives you any numeric value then num function will give you % value.

Try this, if it works!

num((sum({$< cola={1},col2={'J'},col3={'K'} >}Interest)/sum({$< cola={1},col2={'J'},col3={'K'},LTAC_IND={'*'}-{'Y'} >}Ip))*100,'##%')

..

Ashutosh