topic Re: Row wise count required for for Duplicate values,Speacial Char,Blank Rows in QlikView

Row wise count required for for Duplicate values,Speacial Char,Blank Rows

Anonymous — Thu, 23 Jan 2014 11:04:06 GMT

Prodcut	Attribute1	Attribute 2	Attribute 3	Attribute 4
A	1	3	1	1	Count(Duplicate values required)
B	@	@	&	@	count(special characters)
C			W	W	count(Blank rows)

1] For the product A Need Count of Duplicate values

2]For Product B Specail Characters count required

3] For Product C Blank & Null Characters count required

Message was edited by: Anil Kadiri

Re: Row wise count required for for Duplicate values,Speacial Char,Blank Rows

Anonymous — Thu, 23 Jan 2014 12:05:51 GMT

Experts Could pls suggest me some solution for the above

Re: Row wise count required for for Duplicate values,Speacial Char,Blank Rows

jerem1234 — Thu, 23 Jan 2014 14:39:29 GMT

Please find attached. Depending on how your data model is, the attached might work for you. I did it two ways, one where your attributes are all one field and the other where they are separate fields. Also I only did the specials characters @, &. If you want to add more, you can.

PFA

Hope this helps!

Re: Row wise count required for for Duplicate values,Speacial Char,Blank Rows

Anonymous — Thu, 23 Jan 2014 14:48:28 GMT

Awesome work.thank youso much for your great effort

Re: Row wise count required for for Duplicate values,Speacial Char,Blank Rows

Anonymous — Thu, 23 Jan 2014 15:18:20 GMT

For this expression count should be 3 but it is showing 2 .

=count({<Product={A}>}Value) - count({<Product={A}>}distinct Value)

I Need Reptead count

Ans:3.

How can i achive this ?

Re: Row wise count required for for Duplicate values,Speacial Char,Blank Rows

jerem1234 — Thu, 23 Jan 2014 15:44:11 GMT

That is a littler trickier. There are 3 instances of one in your example, but there are 2 distinct values. What that equation is doing is counting the number of repeated values after the first instance. So there are 3 instances of one, but then it is repeated twice.

If you are looking for the number of times a duplicated number appears, then that would be 3. Took a little bit of work, but I think this formula will suffice:

=count({<Product={A}>}if(aggr(nodistinct count(Value), Value) >1,Value))

Hope this helps!

Re: Row wise count required for for Duplicate values,Speacial Char,Blank Rows

Anonymous — Fri, 24 Jan 2014 06:35:30 GMT

Thank u.Its working.