Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

hogo1701
New Contributor II

Set Analysis with Multiple Conditions

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

1 Solution

Accepted Solutions
hogo1701
New Contributor II

Re: Set Analysis with Multiple Conditions

 

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

11 Replies
arulsettu
Honored Contributor III

Re: Set Analysis with Multiple Conditions

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
New Contributor II

Re: Set Analysis with Multiple Conditions

Hi Arul

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

arulsettu
Honored Contributor III

Re: Set Analysis with Multiple Conditions

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
Contributor II

Re: Set Analysis with Multiple Conditions

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
Honored Contributor II

Re: Set Analysis with Multiple Conditions

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

Re: Set Analysis with Multiple Conditions

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
New Contributor II

Re: Set Analysis with Multiple Conditions

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

hogo1701
New Contributor II

Re: Set Analysis with Multiple Conditions

Hi Sunny

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

prajapatiamar38
Contributor II

Re: Set Analysis with Multiple Conditions

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

Community Browser