number formatting error for only particular row>not working

[srini]

Hi Friends,

I would like to change the formatting of my table row(only one row). 

I have tried this expression but which is not giving me the desired formatting. 

=if(Control='GMT Compliance(%)',Num(sum(ConMeasure),'00.00%'),Num( sum(ConMeasure) ,'00.00') )

am I wrong any where? 

Thanks & Regards,

Srini

[tresesco]

Expression looks okay. Now, you have to explain the context in more detail (may be with a sample app) so that we can help.

[bhargav_bhat]

Change the Number formatting to 'Measure Expression' in expression editor

Regards,
Bhargav

[tresesco]

Bhargav, you probably meant 'Expression Default' ?

[bhargav_bhat]

In Expression editor

[Anil_Babu_Samineni · Accepted solution]

If condition holds long, Please post full expression. Can you try this way?

=if(Control='GMT Compliance(%)',Num(sum(ConMeasure),'#.#0%'),Num( sum(ConMeasure) ,'#.#0') )

[tresesco]

Bhargav,

Yeah, I make this mistake often to not check the section where the thread is posted (qlik sense) and by default thinking of qlikview. 😋

[srini]

Thanks Bargav,

=if(Control='GMT Compliance' or Control='Clarity Timesheet Compliance
(%)' ,Num(sum(ConMeasure),'#,##0%'),Num(sum(ConMeasure),'#,##0') )

the above one I used based on your input.... it is working fine.... but when I want to use third dimension name it is not working... 

Then I modified the if statement in the below format but no luck 😞

=if(Control='GMT Compliance',Num(sum(ConMeasure),'#,##0%'),if(Control='Clarity Timesheet Compliance(%)',Num(sum(ConMeasure),'#,##0%'),if(Control='EIM Quality(%)',Num(sum(ConMeasure),'#,##0%'),Num(sum(ConMeasure),'#,##0'))))

any advise to have three dimension?