# App Development

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for
Did you mean:
Contributor II

## How to add column into table which will be calculated disregarding one of two dimensions?

Hi everyone!)
... am relatively new to Qlik Sense but already got tricky task.
Need to add measure column to table which already has two dimensional columns.

Warehouse Code | Product Code | MyMeasureColumn

Tricky part - MyMeasureColumn should be calculated depending on Product Code but also based on data of all warehouses (at which this product is available) not just one warehouse in table row.

If it's possible, how to avoid forced data slicing imposed by one dimensional column of QLik Sense table ?
Exactly table column slicing not selection.

1 Solution

Accepted Solutions
Creator III

Hi Dima,

You can use the TOTAL qualifier:

Sum(TOTAL <[Product Code]> Value)

Regards,

David

6 Replies
Creator III

Hi Dima,

You can use the TOTAL qualifier:

Sum(TOTAL <[Product Code]> Value)

Regards,

David

Contributor II
Author

Thanks, David!

Yes it's right answer to avoid dependence on warehouse selection but unfortunatelly not table column slicing.

Partner

Dima

You are not quite correct. TOTAL is used to override the columns in a table. Set analysis is used to override selections

Sum(TOTAL Value)                                 -- totals all values ignoring all dimensions

Sum(TOTAL <[Product Code]> Value)      -- totals all values by Product Code (ignoring other dimensions)

Sum({<[Product Code]=>} Value)             -- sum values while ignoring user selection of a product code

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Creator III

I'm afraid I don't understand exactly what you are trying to achieve. Can you provide an example with some dummy data?

Do you want also to ignore when a selection is applied on 'Warehouse Code field'?

Contributor II
Author

Sorry, David, indeed I was wrong in my comment and thank you for your answer!
found my logic mistake. Formula I try to succeed with is very cumbersome but I was interested in that particular aspect. Trying to "eat elephant piece by piece".
Once again thank you!

Contributor II
Author

Great explanation, Jonathan!
Now I see that clearly.
Thank you!