Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am trying to get the below to return a %. I get the correct outcome although it is displayed as a decimal and not a %. Any ideas?
=num(count({<CourseName={'*Performance and Development Plan (PAD)'},status={'Enrolled'}>}[IDM Nbr])+
Count({<CourseName={'*Performance and Development Plan (PAD)'},TrainingStatus={'Not Current'}>}[IDM Nbr]))/
num(count({<CourseName={'*Performance and Development Plan (PAD)'}>}[IDM Nbr]),'%')
Cheers, Andrew
Got it – I needed to have the percentage num expression wrap around the entire expression. Added sections highlighted in yellow.
=num(num(count({<CourseName={'*Performance and Development Plan (PAD)'},status={'Enrolled'}>}[IDM Nbr])+ Count({<CourseName={'*Performance and Development Plan (PAD)'},TrainingStatus={'Not Current'}>}[IDM Nbr]))/
num(count({<CourseName={'*Performance and Development Plan (PAD)'}>}[IDM Nbr])),'##.##%')
try like this
num(count({<CourseName={'*Performance and Development Plan (PAD)'},status={'Enrolled'}>}[IDM Nbr])+
Count({<CourseName={'*Performance and Development Plan (PAD)'},TrainingStatus={'Not Current'}>}[IDM Nbr]))/
num(count({<CourseName={'*Performance and Development Plan (PAD)'}>}[IDM Nbr]),'#,##%')
Hi Arul
Thanks. I have tried with '##.##%' and as you have noted above, however it continues to return a decimal only.
may be like this and can you share a sample
num(count({<CourseName={'*Performance and Development Plan (PAD)'},status={'Enrolled'}>}[IDM Nbr])+
Count({<CourseName={'*Performance and Development Plan (PAD)'},TrainingStatus={'Not Current'}>}[IDM Nbr]))/
num(count({<CourseName={'*Performance and Development Plan (PAD)'}>}Total [IDM Nbr]),'#,##%')
Hi Andrew,
What the Arul saying is correct or select Show in Percent% in Number tab both are same . Can you share your app
maybe this:
=num(
(
count( {<CourseName={'*Performance and Development Plan (PAD)'},status={'Enrolled'}>}[IDM Nbr] )
+
Count( {<CourseName={'*Performance and Development Plan (PAD)'},TrainingStatus={'Not Current'}>}[IDM Nbr] )
)
/
count( {<CourseName={'*Performance and Development Plan (PAD)'}>}[IDM Nbr] )
,'#,##0%')
Is this in a chart? If it is, can you check what have you selected on the Number's tab of the chart properties? Make sure you have selected 'Expression Default'.
You can remove num functions from your measures and set the formating of the measure to Number and Percentage.
Hi Sunny
I am using this in a text object. I probably should have mentioned I am using Qlikview also.
Hi Andrew:
Try This:
=num(
((count({<CourseName={'*Performance and Development Plan (PAD)'},status={'Enrolled'}>}[IDM Nbr])
+
Count({<CourseName={'*Performance and Development Plan (PAD)'},TrainingStatus={'Not Current'}>}[IDM Nbr]))
/
count({<CourseName={'*Performance and Development Plan (PAD)'}>}[IDM Nbr])),'#,##0%')