percentage vs dimension value - Qlik Community

Report Inappropriate Content · ‎2015-12-09

Hello

How do i get an expression to calculate the same result as the column 'vs France'

Tahnks in advance for your help

sunny_talwar · ‎2015-12-09

Try this:

Table:

LOAD * Inline [

Country, Sales

France, 200

UK, 300

Belgium, 100

];

Join (Table)

LOAD Sales as FranceSales

Resident Table

Where Country = 'France';

FinalTable:

LOAD Country,

Sales,

Num(Sales/FranceSales, '#.00%') as [vs France]

Resident Table;

DROP Table Table;

sinanozdemir · ‎2015-12-09

And here is the front-end solution in QlikSense:

In the expression (vs France), I typed the below:

I am also attaching qvf.

Hope this helps.

Report Inappropriate Content · ‎2015-12-09

sum( [sales (kE) ] / sum( { < country = { 'France' } > } [sales (kE)]