Set expression to represent shares of business groups region wise

[#1]

Hi Qlik mates,

I face a strange scenario in my project for writing set analysis expression for representing shares of business groups A,B,C which amounts to 100% region wise such as Asia, Middle East, Europe and North America.

Please find the attached picture for detailed information.

Can somebody please advise the set expression for it.

Thanks in Advance

[sunny_talwar]

Would you be able to share some data to help you better?

[#3]

Thanks Sunny.

I have 3 Business groups A,B, and C which spread across regions Asia, Middle East, Europe and North America. I want to represent sales percentages of business groups in these regions in a bar chart as attached in the discussion.

For example,

Asia -> A- 30% , B- 40%, C- 30%

Middle East -> A- 10%, B- 45%, C- 45%

Europe-> A- 45%, B- 40%, C- 15%

North America-> A- 35% ,B- 30%, C- 35%

I need to write a set expression to represent that in a bar chart. Could you please help me in doing so.

Thanks in Advance.

[jagan]

Hi,

Try like this

Dimension: Region, Business Group

Expression: Sum(Sales)/Sum(TOTAL <Region> Sales)

Note: Replace exact dimension and measure names in the above expressions.

Hope this helps you.

Regards,

jagan.

[ecolomer]

See this example.

[#6]

Thank you all.

I got a clue that it can be managed with stacked option within style->subtype in bar chart properties.

The below values can be taken

Dimension: Region, Business Group

Expression: Sum(Sales)/Sum(TOTAL <Region> Sales)

[jagan]

Hi Laxmaiah,

If you got the answer please this thread by giving Correct and Helpful answers to the posts which helps you in finding the Answers, this helps others in finding the answers easily.

Regards,

Jagan.