set expression for region wise sale

[Anonymous]

hello

i need to find particular region or country sales.I am not getting how to write set expression to calculate sales.

please help  me to find out..

[prma7799]

What you want exactly ....

This sale you want to show in text object or in chart ?

[Anonymous]

in chart

[prma7799]

Or what you want to show like MTD YTD

if you want to show simply then

Take dimension as Region

Expression : Sum (Sale) or you can write here set ...

[qlikcheepirishe]

sum({<Country={"INDIA"}>}SALES)

It will display total sales of Country = India

Sum({<Region= {"Asia"}>}SALES)

It will display total sales of Region Asia

Sum({<Region= {"*"}>}SALES)

It will display Total sales of Region

[Anonymous]

i already done this.. but i want show by using set  analysis

[srishsum2017 · Accepted solution]

=sum({<Region={'*'}>}sales)

* denotes- which region you want to see place their name at the place of * otherwise * gives sum of all regions.

[Anonymous]

i am using  this expression  sum({<Country={'Australia','Cuba'}>}Sales)  but its not showing  sales value

[prma7799]

Then simply use AGGR function

like if you have sum(Sales) then use Aggr(sum(Sales),Region)

Aggr(sum(Sales),country)

Or like  put your region field in set  {<Region= {"Latam"}>}

Note: both produce different output.

[prma7799]

Please share some sample application.