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

Qlik Sense Dimension Grouping

Hello,

I have a table with objectives and key results attached to related objectives.

ObjectiveKey ResultsPercentage
Achieve 1M $ in EMEA salesMarketing50%
Achieve 1M $ in EMEA sales
PR25%
Achieve 1M $ in EMEA sales
Demo and Tests40%
Achieve 1M $ in EMEA sales
New Opportunities30%

Im formatting a pivot table and with avg(percentage) calculation, i can find average percentage of an objective, in this case for Achieve 1M$ in EMEA sales is 36,25

I need to count objectives with a %100 percentage as a KPI Item but i couldnt figure.

So i decided to create a calculated dimension. I called it 'Status' and as a formula i wrote : if(avg([percentage]='1','Done','In Progress') But it didnt work.

What can cause that?

Best regards

7 Replies
sunny_talwar

Try this

Avg(TOTAL <Objective> percentage)

Anonymous
Not applicable
Author

Hi Sunny,

I calculated grand average with : avg(aggr(avg(Percentage),Objective))

What i need to do is to count how many objectives have %100 percentage.

sunny_talwar

What is a grand average?

Anonymous
Not applicable
Author

Grand average is the average of all objectives. With your formula im finding another result which is not correct.

But my main goal is to count %100 objectives as i mentioned earlier. And i cant understand why im keep failing.

sunny_talwar

I am unable to follow any of what you are saying....

Anonymous
Not applicable
Author

Ok, sorry for the language. Here is a detailed example:

Objective                     Key Result                                                                                                        Percentage

Verimliligin arttirilmasi  Aylik depo sayimlarinin yapilmasi ve raporlanmasi   Production 30.06.2017   90%

Verimliligin arttirilmasi  Kritik ve atil stok calismasinin tamamlanmasi           Production 30.06.2017   95%

Verimliligin arttirilmasi  Personel egitimlerinin tamamlanmasi                        Production 30.06.2017   90%

Verimliligin arttirilmasi  Merkez uretim alaninin belirlenmesi                          Production 30.06.2017   15%

In this example, objective so called 'Verimliligin arttirilmasi' has 4 key result and each one of them has a percentage. And from these percentages(90%,95%,90%,15%), there is an average for related objective(72.5%)

I have a long table with entries like that.

So know i want to add a KPI item which counts objective with avg(percentage) of 100%

sunny_talwar

May be this

If(Min(TOTAL <Objective> Aggr(Avg(percentage), Objective, [Key Result])) = 1, 'Done', 'In Progress')