Hi- I'm new to Qlikview and I am trying to replicate an expression I have in an excel table:
Basically, this is a SUMIF function with a dynamic variable. Any idea how to recreate this in Qlikview?
Sum(if( condition , ouptput))
let say Qty is the measure and Product is the dimension. so the requirement is to show /list the product never sold
so the expression u can write like this
sum ( if ( sum(Qty)<=0, Product )
also u can check HIC suggestion
Thanks for your response. I need the "condition" to be dynamic such that for line A167, the function sums every value in column H where the value in column A = A167.
I need this calculation to be done in the script. I can attached an example excel file if that would be helpful. Thanks!!
u want to Calculate "Total Credit Hours" using the sum if function? if so then qlikview will do aggregation by default nature. so just use that sum([Credit Hours]) like below,
Yes we can do that,
try like this
LOAD * INLINE [
Student, Credit Hours
load Student,sum([Credit Hours]) as [Total Credit Hours] Resident Data group by Student;