Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
jerfworkS
Contributor
Contributor

QlikView Sum Up Number If Contain that Specific Item

Hi experts, I have a question regarding a expression or set analysis. Example, I want to sum up the whole sales number if the whole transaction contain item 'ItemFree' 

Dataset:

TransactionID Item Sales
1 ItemA 100
1 ItemB 100
1 ItemFree 0
2 Item 200
2 Item 100
3 ItemA 200
3 ItemB 300
3 ItemFree 0

 

Expected result: 

TransactionID Sales
1 200
3 500

 

In the expected result, we should not show TransactionID '2' because there is no item 'ItemFree' in the transaction.

I understand this can be done easily using backend script and change the data schema, but I just want to know if this can be done using expression or set analysis.

Labels (3)
1 Solution

Accepted Solutions
MarcoWedel

Sum({$<TransactionID=P({$<Item={'ItemFree'}>})>} Sales)

 

see also: https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Se...

 

hope this helps

Marco

View solution in original post

2 Replies
MarcoWedel

Sum({$<TransactionID=P({$<Item={'ItemFree'}>})>} Sales)

 

see also: https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/ChartFunctions/Se...

 

hope this helps

Marco

View solution in original post

jerfworkS
Contributor
Contributor
Author

Thanks MacroWedel!