topic Re: Help me in writing the Excel Expression into Qlikview Expression in QlikView

Help me in writing the Excel Expression into Qlikview Expression

hemanthaanichet — Tue, 01 Aug 2017 08:02:54 GMT

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

Re: Help me in writing the Excel Expression into Qlikview Expression

arvind_patil — Tue, 01 Aug 2017 08:06:15 GMT

Hi Hemant,

Best way provide sample excel with expression.

Thanks,

Arvind Patil

Re: Help me in writing the Excel Expression into Qlikview Expression

hemanthaanichet — Tue, 01 Aug 2017 08:44:29 GMT

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

Re: Help me in writing the Excel Expression into Qlikview Expression

rahulpawarb — Tue, 01 Aug 2017 09:03:07 GMT

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

Re: Help me in writing the Excel Expression into Qlikview Expression

hemanthaanichet — Tue, 01 Aug 2017 09:39:22 GMT

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

Re: Help me in writing the Excel Expression into Qlikview Expression

hemanthaanichet — Tue, 01 Aug 2017 09:57:08 GMT

This is Working......

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

Re: Help me in writing the Excel Expression into Qlikview Expression

rahulpawarb — Tue, 01 Aug 2017 10:01:21 GMT

Cheers,

Rahul Pawar