Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
dimaostrovsky
Contributor II
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.

Thanks in advance!

1 Solution

Accepted Solutions
daveamz01
Creator III
Creator III

Hi Dima,

You can use the TOTAL qualifier:

Sum(TOTAL <[Product Code]> Value)

Regards,

David

View solution in original post

6 Replies
daveamz01
Creator III
Creator III

Hi Dima,

You can use the TOTAL qualifier:

Sum(TOTAL <[Product Code]> Value)

Regards,

David

dimaostrovsky
Contributor II
Contributor II
Author

Thanks, David!

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

jonathandienst
Partner
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
daveamz01
Creator III
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'?

dimaostrovsky
Contributor II
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!

dimaostrovsky
Contributor II
Contributor II
Author

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