Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Percent calculation

Good day

I want to calculate a percentage of two measures in Qlik-Sense.

The key figures have already been created in the master elements and also deliver the correct result.

Measure1 - amount of yield: count ({<M.MEASURE_Result = {Error}>} M.MEASURE_VALUE)

Measure2 - total: count (M.MEASURE_VALUE)

Which formula do I have to use here so that I get the percentage of Errorr quantities.

As X% of total amount have an error!

Many Thanks

Stefan

1 Solution

Accepted Solutions
Highlighted
Creator II
Creator II

Hi Stefan,

See calculation below:

Num(count ({<M.MEASURE_Result = {Error}>} M.MEASURE_VALUE)/count (M.MEASURE_VALUE),'#,###%')


Thanks,

Vitalii

View solution in original post

6 Replies
Highlighted
Master II
Master II

I think Measure1/Measure 2 should give you

Sometimes you may have to multiply by 100

(Measure1/Measure2) * 100

Highlighted

May be

Num(count ({<M.MEASURE_Result = {Error}>} M.MEASURE_VALUE),'#,#0%')

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Contributor II
Contributor II

Good Morning!

Thanks for the answer but this is not working!

The result with this is:

Measure Error: 73753

Measure Value: 5141065

Result is: 7375300,00%

So I just get the Errors is %

But the result should be: 1,435%


Do you have an Idea i i get this fixed?

Thanks, Stefan

Highlighted
Master II
Master II

To get your result

Create a new measure

Error%: ([Measure Error] / [Measure Value]) * 100

Measure error and Measure Value are the labels of your expression

Highlighted
Creator II
Creator II

Hi Stefan,

See calculation below:

Num(count ({<M.MEASURE_Result = {Error}>} M.MEASURE_VALUE)/count (M.MEASURE_VALUE),'#,###%')


Thanks,

Vitalii

View solution in original post

Contributor II
Contributor II

Hello Vitalii

thanks! Now it is working!

br Stefan