Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I just started learning Qlikview last week, so i am a total newbie.
I am trying to figure out the following:
I made a straight table that shows all available stock per item, Filtered by Collection year 2017 and in Warehouse X.
Available stock is calculated with a set expression:
sum({ALT_STATE2<StockMove_Type={"N"}>}StockMove_Quantity)
All my list boxes and my Table box are using ALT_STATE1
Because i use ALT_STATE2, which is an empty selection for my expression it calculates all the stock moves that ever happend (this is wanted behavior), but as a result it destroys my table selection which should still use ALT_STATE1.
My question:
How do i calculate all the stockmoves outside my selection (ALT_STATE2), but show the results in my selection (ALT_STATE1).
something like this
sum({ALT_STATE2<StockMove_Type={"N"},year_field = ALT_STATE1 :: year_field, Warehouse_field= ALT_STATE1::Warehouse_field >}StockMove_Quantity)
As you said you are a beginner you may want to check out this document
regards
Pradosh