Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Would you be able to share some data to help you better?
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.
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.
See this example.
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)
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.