Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

always show totals no matter which warehouse is chosen

Hi

I want to display total stock on hand even if a specific warehouse is chosen.  Let me illustrate.

In the table below I have 2 items, A & B with quantity on hand for each location.  I want to create a chart (straight table) for total stock on hand , so that if i select a specific warehouse , it must still give me total stock hand.

So, if i have a warehouse list box, and i select warehouse 1, the value must still show me stock on hand for A= 200 and for B=1,100)

ITEMNOWarehouseStock on Hand
A130
A280
A390
B1500
B2200
B3400

How do i create this formula.

Please help

Thank you

kind regards

Nayan

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try this expression

=Sum({<Warehouse=>} StockOnHand)

The above expression ignore Warehouse selection.

Regards,

Jagan.

View solution in original post

2 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Try this expression

=Sum({<Warehouse=>} StockOnHand)

The above expression ignore Warehouse selection.

Regards,

Jagan.

Not applicable
Author

Hi Jagan

Thank you .  It worked.  Much appreciated.

kind regards

Nayan