# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
cancel
Showing results for
Did you mean:
Partner - Creator II

## Filter by dimension

I'd like to add a filter by dimension instead of by value ; say I have field A {1, 2, 3} and field B {4, 5, 6} that correspond for example to number of sales for employee A and employee B or each product.

I want a pie chart with sales per product, so I have a dimension that is "Product name" and a measure that is Sum(A) + Sum(B).

If I add a filter item (the last one in graphs, I have Qliksense in French which doesn't help, sorry for mistranslations), I can only add a Dimension which then shows all values to filter by Value.

I want to be able to select A or B to show their individual sales on the same chart, how can I filter this ?

Reality is more complex than that but the analogy simplifies things for explanation purposes.

28 Replies
Partner - Creator II

Well that was a wild ride. Glad it's solved!

Could you mark/like one of our answers with the formula's as the answer? That way people know which one to use in the future.

Partner - Creator II
Author

I accepted the one with a working solution.

Partner - Creator II
Author

One last thing :

Let's say the values for a sale are 18 and 12 for "A without B" and "B" respectively ; when I filter on those and mouse over the graph, it simply says "40" - that makes sense, we're adding them to "filter".

Is there a way ton conserve the split so that is shows "A without B : 18" and "B : 12" ?

Partner - Creator II
Author

30* it*

Typos, can't edit posts...

Partner - Creator II

You can actually edit posts by pressing the 3 dots.

I would solve your new problem by editing the label. So instead of Sales you get something like this:

``Total Sales (15 product A, 10 product B): 25``

Can basically make it as nice as you want, but as far as I know only on the label side, you can't really split the right side.

Partner - Creator II
Author

Would it be dynamic though ?

I don't have the 3 dots on my browser version ; I just noticed I do have them on my phone though.

Partner - Creator II

Yes, it would be dynamic, because it would be a formula that also gets calculated.

Partner - Creator II
Author

I shall check that out tomorrow 🙂

Partner - Creator II
Author

Could you help me doing this ?

My value fields appear as text in the label, like

``='A without B : [SaleProductAwB] B : [SaleProductB] C : [SaleProductC] D : [SaleProductD]'``

will come out as

``A without B : [SaleProductAwB] B : [SaleProductB] C : [SaleProductC] D : [SaleProductD]``

;

And if I remove them from the quotes like so :

``='A without B : ' & [SaleProductAwB] & 'B : ' & [SaleProductB] & 'C : ' & [SaleProductC] & 'D : ' & [SaleProductD]``

I get this in the label :

``A without B : B : C : D :``