Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

How to get count of matching columns in straight table

Hi I created a straight table like this

x y

1 1

1 2

2 5

2 2

I want to count where x and y have equal values . I want to compare only straight table data not entire data.

Please help

Tags (1)
4 Replies
MVP
MVP

Re: How to get count of matching columns in straight table

In the straight table take an expression like: =Count(Total If(x=y,x))

Re: How to get count of matching columns in straight table

HI

In load, Try like this

Load If(x=y, 1) as Flag from tablename;

Then in expression

Count({<Flag = {1}>} x)

antoniotiman
Honored Contributor III

Re: How to get count of matching columns in straight table

See attachment  

Regards

Not applicable

Re: How to get count of matching columns in straight table

Hi,

Try this Expression

=Sum(Total if(x=y,1,0))

Regards,

Vivek

Community Browser