Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
plz tell me the logic.. i am using personal edition of qlikview so cant opn qvw....
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
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???
Hi,
Don't use NUM# rather use NUM
Num# is to process input while Num is to show output.
...
Ashutosh
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...
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