Question regarding Alternate States and Set expressions.

Wed, 25 Nov 2020 16:16:04 GMT

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).

Re: Question regarding Alternate States and Set expressions.

pradosh_thakur — Mon, 16 Oct 2017 18:12:50 GMT

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

topic Re: Question regarding Alternate States and Set expressions. in QlikView

Question regarding Alternate States and Set expressions.

Re: Question regarding Alternate States and Set expressions.