topic Re: Count against Dim2 in QlikView

Count against Dim2

sylvesterjesuda — Tue, 31 Jul 2018 14:29:22 GMT

Hi,

I have a example data like below in which I would like to take the count of Dim 2 against Dim 1.

(ie) In the Chart, I want Dimension as Dim1, In the expression, I want the Count 3 for A.

Can anyone help to bring the solution for it, since if I use the count formula, I get the count for A as 2 which is wrong.

Example Data:-

Best Regards

Sylvester J

vishsaggi — Tue, 31 Jul 2018 15:29:42 GMT

Why you have to get three? Is the above data sample right?

sylvesterjesuda — Tue, 31 Jul 2018 16:30:11 GMT

Yes its right... Its just like we use Countif function in excel

See the result in excel below, how can it be done in expression as result where the Dim1 should be in expression.

vishsaggi — Tue, 31 Jul 2018 18:29:42 GMT

May be this?

= COUNT (TOTAL <Dim2> Dim2)

vishsaggi — Tue, 31 Jul 2018 18:42:49 GMT

May be rwunderlich‌ stalwar1‌ can give any suggestions or ideas please...

Lisa_P — Fri, 03 Aug 2018 02:18:42 GMT

Why are you loading Dim1 ? Is it to limit Dim2 values ? There is no relevance to the row levels.

If you only load Dim2, you can count how many of each one, the only thing you are looking for is matching the Dim1 values.

tamilarasu — Fri, 03 Aug 2018 05:18:44 GMT

Hi Sylvester,

Try this.

Substringcount(Concat(Total Dim2,'|'),Dim1)

sylvesterjesuda — Fri, 03 Aug 2018 15:44:35 GMT

Heartful Thanks Tamilarasu, Your answer is perfect and it is an timly help....