percentage vs dimension value

[#1]

  Hello

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

	sales (kE)	vs France
France	200	100,00%
uk	300	150,00%
belgiuem	100	50,00%

Tahnks in advance for your help

[sunny_talwar]

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]

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.

[#4]

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