Metric with filter

[#1]

Hello,

I want to show a value in % that will describe how much of sales is in US vs. all countries. This is just an example scenario.

Please see grid below. Country and Sales are column names taken from warehouse.

Country               Sales

US                    1,000,000
Canada              5,000
Germany            6,500
China                12,000

Metric that I want to build is an expression:  SUM (Sales) where {Country = US} / SUM (Sales)(Sales for all countries). Can you please paste me the script that I need to put in my expresion in grid? I am still using free version of QlikView so I can’t really open any example made in this tool.

Thanks!

[rubenmarin · Accepted solution]

Hi, not sure to understand the requirements, you want a expression like:

Sum(TOTAL {<Country={'US'}>} Sales)/Sum(TOTAL Sales)