Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi..
Can anyone help me how can i write the below expression in Qlikview
=SUMIF('Jun17'!$AG:$AG, 'FF-JUN'!$E3&"YES", 'Jun17'!$AB:$AB)
Jun17'!$AG:$AG = IF($P2 <> "Sample" , IF ( U2 > 0, H2 ,0 ) , 0)
P2 = IteamCategory
U2 = Qtyvalidated
H2 = Name
Jun17'!$AB:$AB = Received data
I tired few values are matching but few are not...
Regards
hemanth
Would you be able to share your Excel?
Brother any idea u have for this.... pls let me know....
Looks like you need ApplyMap() to map the mapping table.
Anil Applymap is not possible i think because the raw data is a single file