Expression

devarasu07 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

=Sum({<ArticleNo = p({<ShopCategory = {'WAREHOUSE'}>}) * p({<ShopCategory = {'RETAIL'}>}) > + <ArticleNo= p({<ShopCategory = {'RETAIL'}>}) >} soh)

Need to use above logic (ShopCategory filter) into below set analysis expression, do you have any idea to change it?

=Pick(Match(ValueList('A Stocks', 'B Stocks', 'C Stocks'), 'A Stocks', 'B Stocks', 'C Stocks'),

Sum({<ArticleNo = p({StockA}ArticleNo)>}soh),

Sum({<ArticleNo = p({StockB}ArticleNo)*e({StockA}ArticleNo)>}soh),

Sum({<ArticleNo = p({StockC}ArticleNo)*e({StockB}ArticleNo)>}soh))

Note: here StockA, StockB and StockC are alternate State

Thanks!

Regards,Dev

Re: Expression

devarasu07 — Wed, 14 Dec 2016 08:51:37 GMT

Managed to fix,

=Pick(Match(ValueList('A Stocks', 'B Stocks', 'C Stocks'), 'A Stocks', 'B Stocks', 'C Stocks'),

Sum({<ArticleNo = p({<ShopCategory = {'WAREHOUSE'},ArticleNo = p({StockA}ArticleNo)>}) * p({<ShopCategory = {'RETAIL'},ArticleNo = p({StockA}ArticleNo)>}) > + <ArticleNo= p({<ShopCategory = {'RETAIL'},ArticleNo = p({StockA}ArticleNo)>})>} soh),

Sum({<ArticleNo = p({<ShopCategory = {'WAREHOUSE'},ArticleNo = p({StockB}ArticleNo)*e({StockA}ArticleNo)>}) * p({<ShopCategory = {'RETAIL'},ArticleNo = p({StockB}ArticleNo)>})*e({StockA}ArticleNo) > + <ArticleNo= p({<ShopCategory = {'RETAIL'},ArticleNo = p({StockB}ArticleNo)*e({StockA}ArticleNo)>})>} soh),

Sum({<ArticleNo = p({<ShopCategory = {'WAREHOUSE'},ArticleNo = p({StockC}ArticleNo)*e({StockB}ArticleNo)>}) * p({<ShopCategory = {'RETAIL'},ArticleNo = p({StockC}ArticleNo)>})*e({StockB}ArticleNo) > + <ArticleNo= p({<ShopCategory = {'RETAIL'},ArticleNo = p({StockC}ArticleNo)*e({StockB}ArticleNo)>})>} soh))

topic Expression in QlikView

Expression

Re: Expression