3 Replies Latest reply: Feb 23, 2012 3:02 AM by Juan Vitantonio

# Add expression to group of expressions without losing dimension

Hi everyone,

I have only been working with qlikview for a month, so I have a lot of doubts when I am developing something, and these discussions have been a great help to me.

However there is something that I still cannot figured it out, and I have not find a solution is this forum or within the reference guide.

You can find enclosed an example that I have created to illustrate my problem:

I want to have a chart with both sales and Market Share, but calculated as an Index (with average 2011 as the index base), I have grouped the expressions in the chart, and used Time Periods and Market (cyclic group of Product and Pack) as dimensions – chart 1. This works fine.

Then I wanted to know the shop sales and Market Share Index – chart 2.

The problem is when I combine them together (chart 3). I wanted to have market share index for both product A and B and for the total market, but when I insert the expression in the same chart as the first one I lose the possibility to see the market as a dimension. Does anyone know how to solve this??

I really need some urgent help. If this can be solved, then the perfect solution would be to have the cyclic expression group, that would allow me to see both products and shop, and in market share and sales (depending on the selection).

Joana

• ###### Add expression to group of expressions without losing dimension

Try groupiong the expression on the 3rd graph as you did with the other 2.

• ###### Add expression to group of expressions without losing dimension

It would not work, because I want to see both expressions at the same time (so I can see my products index and still compare them to my shop index)

• ###### Add expression to group of expressions without losing dimension

Then "Market" is not a dimenion but an expresion. It depends on what you are working on. You can't mix oranges with apples. If you make a count for product and market, then move Market to the expression also.