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: 
helen_pip
Creator III
Creator III

Formatting in text box not working

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

1 Solution

Accepted Solutions
boorgura
Specialist
Specialist

=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')

View solution in original post

3 Replies
boorgura
Specialist
Specialist

=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')

helen_pip
Creator III
Creator III
Author

Hello Rakesh

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

boorgura
Specialist
Specialist

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