Set Analysis with Multiple Conditions

[hogo1701]

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

[arulsettu]

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]),'#,##%')

[hogo1701]

Hi Arul

Thanks. I have tried with '##.##%' and as you have noted above, however it continues to return a decimal only.

[arulsettu]

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]),'#,##%')

[keerthika]

Hi Andrew,

   What the Arul saying is correct or select Show in Percent% in Number tab both are same . Can you share your app

[agigliotti]

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

[sunny_talwar]

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'.

[facettti]

You can remove num functions from your measures and set the formating of the measure to Number and Percentage.

[hogo1701]

Hi Sunny

I am using this in a text object. I probably should have mentioned I am using Qlikview also.

[prajapatiamar38]

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