# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for
Did you mean:
Master II

## Expression

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

1 Solution

Accepted Solutions
Master II
Author

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