Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

number formating using set analysis

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

15 Replies
Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

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???

Not applicable
Author

Hi,

Don't use NUM# rather use NUM

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

...

Ashutosh

Not applicable
Author

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...

Not applicable
Author

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