7 Replies Latest reply: Jul 17, 2017 11:20 AM by Sunny Talwar

# 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

• ###### Re: Qlik Sense Dimension Grouping

Try this

Avg(TOTAL <Objective> percentage)

• ###### Re: Qlik Sense Dimension Grouping

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.

• ###### Re: Qlik Sense Dimension Grouping

What is a grand average?

• ###### Re: Qlik Sense Dimension Grouping

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.

• ###### Re: Qlik Sense Dimension Grouping

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

• ###### Re: Qlik Sense Dimension Grouping

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%

• ###### Re: Qlik Sense Dimension Grouping

May be this

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