topic Re: How to add column into table which will be calculated disregarding one of two dimensions? in App Development

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

Anonymous — Tue, 30 May 2017 07:40:16 GMT

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!

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

daveamz — Tue, 30 May 2017 08:21:55 GMT

Hi Dima,

You can use the TOTAL qualifier:

Sum(TOTAL <[Product Code]> Value)

Regards,

David

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

Anonymous — Tue, 30 May 2017 08:45:39 GMT

Thanks, David!

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

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

jonathandienst — Tue, 30 May 2017 09:29:51 GMT

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

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

daveamz — Tue, 30 May 2017 09:30:24 GMT

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'?

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

Anonymous — Tue, 30 May 2017 09:53:51 GMT

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!

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

Anonymous — Tue, 30 May 2017 09:55:59 GMT

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