Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi Dima,
You can use the TOTAL qualifier:
Sum(TOTAL <[Product Code]> Value)
Regards,
David
Hi Dima,
You can use the TOTAL qualifier:
Sum(TOTAL <[Product Code]> Value)
Regards,
David
Thanks, David!
Yes it's right answer to avoid dependence on warehouse selection but unfortunatelly not table column slicing.
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
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'?
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!
Great explanation, Jonathan!
Now I see that clearly.
Thank you!