Qlik Community

Ask a Question

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 
Search instead for 
Did you mean: 
devarasu07
Master II
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
devarasu07
Master II
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))

View solution in original post

1 Reply
devarasu07
Master II
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))

View solution in original post