
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- « Previous Replies
-
- 1
- 2
- Next Replies »
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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])),'##.##%')


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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]),'#,##%')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Arul
Thanks. I have tried with '##.##%' and as you have noted above, however it continues to return a decimal only.


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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]),'#,##%')


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Andrew,
What the Arul saying is correct or select Show in Percent% in Number tab both are same . Can you share your app


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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%')

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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'.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can remove num functions from your measures and set the formating of the measure to Number and Percentage.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Sunny
I am using this in a text object. I probably should have mentioned I am using Qlikview also.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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%')

- « Previous Replies
-
- 1
- 2
- Next Replies »