Announcements
[WEBINAR] Accenture & Qlik: Accelerating BI Migration to SaaS with Qlik on Dec 13th: REGISTER
cancel
Showing results for
Did you mean:
Creator III

## Help me in writing the Excel Expression into Qlikview Expression

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

6 Replies
Partner - Specialist III

Hi Hemant,

Best way provide sample excel with expression.

Thanks,

Arvind Patil

Creator III
Author

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

Specialist III

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

Creator III
Author

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

Creator III
Author

This is Working......

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

Specialist III

Cheers,

Rahul Pawar

Community Browser