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: 
rathnam_qv
Creator
Creator

Selection based Percentage format

Hi All,

i am show GP and GP% based on selection.

Issue is while selection GP%...value is displaying like 6.32 but i want to display it as 6.32%.

My expression is If(String='GP%', Num( (Value1-Value2) /Value1,'0.00%')

Need your suggestions.

Thanks,

Rathnam.

6 Replies
Anonymous
Not applicable

Try this

If(String='GP%', (Value1-Value2) /Value1)

and in Formatting->simple->keep in percentage

YoussefBelloum
Champion
Champion

Hi,

you are maybe ovveriding the format on the Number section.

rathnam_qv
Creator
Creator
Author

Hi Aparna,

i am calling two conditions in the same expression,

IF(String='GP$',Num(condtion1,'#,##0'),

If(String='GP%', Num( (Value1-Value2) /Value1,'0.00%'))


Kept Format is "AUTO"


GP$ format is working fine. only issue with GP% format.


Thanks,

Rathnam.

rathnam_qv
Creator
Creator
Author

Hi Youssef,

I kept format as AUTO.

Thanks,

Rathnam.

Anonymous
Not applicable

Try with number formatting->measure expression

rathnam_qv
Creator
Creator
Author

Number format will apply to both the selections...i want to apply it only for GP% selection.