Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
london1980
New Contributor

Sum function with 2 Conditions

Hi All,

I've got this sum function that gives me the total of Available_Qty where Country_Code is 7

sum({<[Country_Code]={'$(=7)'}>} [Available_Qty])

I want to add one more condition into this

"and where Warehouse_Code is A1"

Can anyone help me adding this into the function?

thanks

MT

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Sum function with 2 Conditions

You don't need a dollar sign expansion for a constant value.

Try

sum({<[Country_Code]={'7'}, [Warehouse_Code] = {'A1'} >} [Available_Qty])

2 Replies
MVP
MVP

Re: Sum function with 2 Conditions

You don't need a dollar sign expansion for a constant value.

Try

sum({<[Country_Code]={'7'}, [Warehouse_Code] = {'A1'} >} [Available_Qty])

london1980
New Contributor

Re: Sum function with 2 Conditions

Works beautifully, many thanks!

Community Browser