# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

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.

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

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

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

MVP

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

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.

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.

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