topic Formatting in text box not working in QlikView

Formatting in text box not working

helen_pip — Thu, 07 Jul 2016 16:22:10 GMT

Dear all

I am calculating an expression in a text box, which unfortunately does not format to set format I have written

The calculation is:

=100-(Num(Count({$<FactDateNum ={">=$(=v_Start_Date_OP)<=$(=v_End_Date_OP)"}, OP_Atd_Ethnic_Code={'Z', '99'}>} If(OP_Atd_Outcome_Type= 'ACTION',OP_Atd_ID)) /

Count({$<FactDateNum ={">=$(=v_Start_Date_OP)<=$(=v_End_Date_OP)"}>} If(OP_Atd_Outcome_Type= 'ACTION',OP_Atd_ID))*100,'0.0'))

The issue is surrounding the first part of the equation as putting 100- at the beginning, seems to ignore the formatting and I get 91.52689164 instead of 91.52

Does anyone have any ideas as to why the 100 is causing me problems

Kind Regards

Helen

Re: Formatting in text box not working

boorgura — Thu, 07 Jul 2016 16:23:47 GMT

=Num(100-(Count({$<FactDateNum ={">=$(=v_Start_Date_OP)<=$(=v_End_Date_OP)"}, OP_Atd_Ethnic_Code={'Z', '99'}>} If(OP_Atd_Outcome_Type= 'ACTION',OP_Atd_ID)) /

Count({$<FactDateNum ={">=$(=v_Start_Date_OP)<=$(=v_End_Date_OP)"}>} If(OP_Atd_Outcome_Type= 'ACTION',OP_Atd_ID))*100),'0.0')

Re: Formatting in text box not working

helen_pip — Thu, 07 Jul 2016 16:26:20 GMT

Hello Rakesh

Thank you! This now works! Why I didn't think of that, I will never know

Re: Formatting in text box not working

boorgura — Thu, 07 Jul 2016 16:27:48 GMT

Happens all the time! Helps to have an extra pair of eyes to take a look!