topic Re: Exclude Year selection in expression in QlikView

Exclude Year selection in expression

vireshkolagimat — Tue, 22 Jan 2019 07:35:33 GMT

Hi All,

I've the below expression which calculate the sum InvQty based on the set analysis expression.

=sum({<StockTransType={'STKTKEFULL'}, TransNo={'$(=MaxString(TransNo))'}, Year= >}InvQty)

I don't want the exp value to change if they make selections in Year list box so i have excluded it in the exp.

But if select the Year list box, the value is changing. I need to keep this value as constant.

what is wrong in my expression? Thanks

Vegar — Tue, 22 Jan 2019 08:09:03 GMT

I guess you would need to add the set into your maxString() function as well.

=sum({<
     StockTransType={'STKTKEFULL'}, 
     TransNo={'$(=MaxString({<StockTransType={'STKTKEFULL'},Year=>}TransNo))'}, 
     Year= >}InvQty)

vireshkolagimat — Tue, 22 Jan 2019 12:07:25 GMT

Hi, Thanks for suggestion. Its working fine.