topic Re: set expression for region wise sale in QlikView

set expression for region wise sale

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

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..

Re: set expression for region wise sale

prma7799 — Thu, 02 Nov 2017 09:34:58 GMT

What you want exactly ....

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

Re: set expression for region wise sale

Anonymous — Thu, 02 Nov 2017 09:35:50 GMT

in chart

Re: set expression for region wise sale

prma7799 — Thu, 02 Nov 2017 09:38:28 GMT

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 ...

Re: set expression for region wise sale

qlikcheepirishe — Thu, 02 Nov 2017 09:43:24 GMT

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

Re: set expression for region wise sale

Anonymous — Thu, 02 Nov 2017 09:45:50 GMT

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

Re: set expression for region wise sale

srishsum2017 — Thu, 02 Nov 2017 09:50:45 GMT

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

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

Re: set expression for region wise sale

Anonymous — Thu, 02 Nov 2017 09:51:18 GMT

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

Re: set expression for region wise sale

prma7799 — Thu, 02 Nov 2017 09:52:14 GMT

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.

Re: set expression for region wise sale

prma7799 — Thu, 02 Nov 2017 09:53:20 GMT

Please share some sample application.

Re: set expression for region wise sale

srishsum2017 — Thu, 02 Nov 2017 09:54:48 GMT

prachi please specify where you want to show the sales value, if you want on bar chart so please use show data points property, otherwise you can use simple a table to show this

Re: set expression for region wise sale

MK9885 — Thu, 02 Nov 2017 13:56:45 GMT

If you are talking about displaying Sales value on chart you can hover over a bar and you'll see the sales.

check the box 'Values on Data Points' and the sales values would show up on bar.

Re: set expression for region wise sale

Anonymous — Fri, 03 Nov 2017 06:11:58 GMT

i am not talking about this..

i want show total sales by region ,country, state, and city chart.

Re: set expression for region wise sale

MK9885 — Fri, 03 Nov 2017 12:59:27 GMT

Use Country, Region, State, City and State as Dimensions.

In measure use Sum(Sales)

This would gives sales of all the dimensions with no filter.

but if you want specific filters, use set analysis.