topic Re: Count of String in expression in QlikView

Count of String in expression

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Looking for product count based on product ID in expression but product Count should display product name (string) ..like how we display in table and count should be 4.

Product ID	sum(sale)	Product Name	Product count
1	10	ABC	ABC
2	20	DGC	DGC
3	10	JHG	JHG
4	20	HBC	HBC
Total	60		4

Thanks in advance

Re: Count of String in expression

Anil_Babu_Samineni — Fri, 06 Jan 2017 08:18:33 GMT

Why not, Simply Count([Product Name])

Re: Count of String in expression

Anonymous — Fri, 06 Jan 2017 08:53:58 GMT

Is that you want to display

Product name in Product count field? and
in Product count field - total you want to display 4 ?

Re: Count of String in expression

varshavig12 — Fri, 06 Jan 2017 08:56:56 GMT

Something like this ,

Re: Count of String in expression

Fri, 06 Jan 2017 09:19:44 GMT

Yes i want to display

Product name in Product count field and
in Product count field i want to display total count 4 . This total count is based on Product ID

Re: Count of String in expression

varshavig12 — Fri, 06 Jan 2017 09:25:34 GMT

Output:

Dim:

Exp:

Re: Count of String in expression

Anonymous — Fri, 06 Jan 2017 09:31:45 GMT

Try this expression: if(Dimensionality() = 0, Count(DISTINCT [Product ID]), [Product Name])

Hope this is helpful to you.

Re: Count of String in expression

varshavig12 — Fri, 06 Jan 2017 09:46:45 GMT

Kavya can try it.

Re: Count of String in expression

Fri, 06 Jan 2017 10:27:55 GMT

Hi Kavya Shree,

I think are you Expecting only total count? if yes,Do like this

Just write the Expression If(product-id = product-id,' ') just give the space

and select text count inTotal mode.

then you get out put like this

Re: Count of String in expression

Fri, 06 Jan 2017 11:41:11 GMT

Thanks everyone