Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
vitaliichupryna
Creator III
Creator III

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
MK9885
Master II
Master II

I think Measure1/Measure 2 should give you

Sometimes you may have to multiply by 100

(Measure1/Measure2) * 100

Anil_Babu_Samineni

May be

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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)
Anonymous
Not applicable
Author

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

MK9885
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

vitaliichupryna
Creator III
Creator III

Hi Stefan,

See calculation below:

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


Thanks,

Vitalii

Anonymous
Not applicable
Author

Hello Vitalii

thanks! Now it is working!

br Stefan