Help me in writing the Excel Expression into Qlikview Expression

[hemanthaanichet]

Hi Guys.....

help me out in converting the excel expression into qlikview expression

Below is my Excel formula

'Jun17'!$AF:$AF = IF($P2<>"Sample",IF(T2>0,H2,0),0)

P2 = Item Category

T2 = QtyShipped

H2 = Name

=COUNTIF( 'Jun17'!$AF:$AF , 'FF-JUN'!$E3)

'FF-JUN'!$E3 = Name

Regards

Hemanth

[arvind_patil]

Hi Hemant,

Best way provide sample excel with expression.

Thanks,

Arvind Patil

[hemanthaanichet]

Actually the data is confidential that is the reason i wil provide the sample to at the best

[rahulpawarb]

May be this:

//'Jun17'!$AF:$AF = IF($P2<>"Sample",IF(T2>0,H2,0),0)
If([Item Category] <> 'Sample', If([QtyShipped] > 0, [Name], 0), 0)


//=COUNTIF( 'Jun17'!$AF:$AF , 'FF-JUN'!$E3)
=Count(If(Match( 'Jun17'!$AF:$AF , [Name]), 1, 0))

Note: Replace the 'Jun17'!$AF:$AF with respective field in above expressions.

Regards!

Rahul Pawar

[hemanthaanichet]

nope.... the results are not matched....

[hemanthaanichet]

This is Working......

=Sum(If(Match( If([Item Category] <> 'Sample', If([QtyShipped] > 0, [Name], 0), 0) , [Name]), 1, 0))

[rahulpawarb]

Cheers,

Rahul Pawar