Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

rathnam_qv
Contributor

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
qlik_aparnav
Contributor II

Re: Selection based Percentage format

Try this

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

and in Formatting->simple->keep in percentage

YoussefBelloum
Esteemed Contributor

Re: Selection based Percentage format

Hi,

you are maybe ovveriding the format on the Number section.

rathnam_qv
Contributor

Re: Selection based Percentage format

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
Contributor

Re: Selection based Percentage format

Hi Youssef,

I kept format as AUTO.

Thanks,

Rathnam.

qlik_aparnav
Contributor II

Re: Selection based Percentage format

Try with number formatting->measure expression

rathnam_qv
Contributor

Re: Selection based Percentage format

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

Community Browser