Qlik Community

Qlik Sense Cloud Discussions

lemon_lyman
New Contributor II

Issue linking tables

Good morning,

I work with QlikSense Cloud, and I have issues linking two tables.

My company has 2 brands A and B, with products in a Market splited in 2 Segments X & Y.

I linked a table Products (with the volume of my company), with a table Market (total volume of the Market per Segment), with the Key [Segment]

My issue is that Brnd B has product in only one section of the market, segment Y.

=>Hence, if I calculate market Share [Volume] / [Market], QlikSense only take into account the market Segment Y, and not the sum of the Market X+Y.

Is there a solution? Given I want as well to be able to calculate the Market Share per segment.

Thanks a lot, I tried to be as clear and factual as I could.

Pierre

1 Solution

Accepted Solutions

Re: Issue linking tables

How exactly are you calculating the Sum of Market? May be you need to add TOTAL qualifier to do this?

What does the TOTAL qualifier do?

2 Replies
Employee
Employee

Re: Issue linking tables

Hello Pierre - this was very clear - thanks for that, let me see if one of our resident experts can assist.

gwassenaar‌ or stalwar1‌ - do you have any advice for Pierre?

Thank you.

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik

Re: Issue linking tables

How exactly are you calculating the Sum of Market? May be you need to add TOTAL qualifier to do this?

What does the TOTAL qualifier do?

Community Browser