topic Re: Percent Problem in QlikView

Percent Problem

Anil_Babu_Samineni — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

PFA of my image. Here i want to see percentage. If syntax looking like bad then use the Variable, Please

My Expression is

LET Variable = Avg({$<[2014 rep] = , [2014 name] -= {'Key Message Delivery','Sales Objective Category'}>} [2014 Score]);

Avg({$<[2014 rep] = , [2014 name] -= {'Key Message Delivery','Sales Objective Category'}>} [2014 Score])

(Avg(total {$<[2014 rep] = , [2014 name] -= {'Key Message Delivery','Sales Objective Category'}>} [2014 Score])/100)*100

- Anil

Tue, 05 Jul 2016 11:31:05 GMT

Hi Anil could you please share your data ?

Anonymous — Tue, 05 Jul 2016 11:36:38 GMT

Hi Anil,

Are <50, 50-70, >70 values of your dimension.

Share sample data.

Anil_Babu_Samineni — Tue, 05 Jul 2016 11:40:10 GMT

PFA

Tue, 05 Jul 2016 11:40:25 GMT

try this one

chart properties ->expression tab->click the check box relative

Anil_Babu_Samineni — Tue, 05 Jul 2016 11:44:08 GMT

Hari,

The problem is expression, if we check that it will showing different.

Anil_Babu_Samineni — Tue, 05 Jul 2016 12:11:26 GMT

Hello,

I got the solution. Can you please let me know how to use that variable into expression.

Might be you all will help me about second task.

LET 2014_Variable = Avg({$<[2014 rep] = , [2014 name] -= {'Key Message Delivery','Sales Objective Category'}>} [2014 Score]);

I am expecting something like below.

$(2014_Variable)

(Avg(total {$<[2014 rep] = , [2014 name] -= {'Key Message Delivery','Sales Objective Category'}>} [2014 Score])/100)*100

- Anil