topic Re: COUNT() used in expression in QlikView

COUNT() used in expression

Anonymous — Mon, 11 Jan 2016 14:25:32 GMT

Hi,

I have a COUNT() statement which looks like this in one of the expressions for a chart:

count ( {<Col1_in_Table1={1}>} DISTINCT Col2_in_Table2 )

Can someone let me know if I’m interpreting this statement correctly or not.

So if my data looks like this:

Col1_in_Table1	Col2_in_Table2
1	X
1	X
1	Y
0	X
0	X

Does the COUNT() in above return 2?

Thank you.

Re: COUNT() used in expression

swuehl — Mon, 11 Jan 2016 14:31:23 GMT

Yes, two distinct Col2_in_Table2 values X and Y where Col1_in_Table1 equals 1.

But are the two columns really located in a single table or two?

Re: COUNT() used in expression

Peter_Cammaert — Mon, 11 Jan 2016 14:32:08 GMT

That's correct if you use this expression in, say a text box or a chart or straight table without dimensions.

If you do apply dimensions to your expression, the dimension values may further reduce the result of this expression.

Best,

Peter

Re: COUNT() used in expression

miguelbraga — Mon, 11 Jan 2016 14:32:39 GMT

Yes it returns 2

Regards,

Re: COUNT() used in expression

Anonymous — Mon, 11 Jan 2016 14:36:32 GMT

Thanks. There are two tables involved here.

Re: COUNT() used in expression

Anonymous — Mon, 11 Jan 2016 14:37:43 GMT

Thank you for the quick replies.

Just wanted to make sure I understand the syntax as i'm troubleshooting an app that was written by someone else.

Re: COUNT() used in expression

Peter_Cammaert — Mon, 11 Jan 2016 14:38:22 GMT

Moreover, as Stefan already indicated, the location may have an impact as well. You seem to place Col1 in Table1 and Col2 in Table2. Two separate tables then. How are rows in each table associated? No association will still return 2 as long as you do not select anything in Col2.

Re: COUNT() used in expression

miguelbraga — Mon, 11 Jan 2016 14:39:44 GMT

Do you need my qvw? If not, does my answer gave you what you need? If so put it as the correct answer Have nice job.

Regards,

Re: COUNT() used in expression

Anonymous — Mon, 11 Jan 2016 14:43:12 GMT

Hi Peter,

Yes, there's another column which links these two tables. I just gave a very simplied example but thanks for

pointing this out.

Re: COUNT() used in expression

Anonymous — Mon, 11 Jan 2016 14:44:00 GMT

Hi Miguel,

Please post your qvw. QV is new to me.

Thanks

Re: COUNT() used in expression

miguelbraga — Mon, 11 Jan 2016 14:52:18 GMT

Here it is:

Regards,

Re: COUNT() used in expression

swuehl — Mon, 11 Jan 2016 14:58:17 GMT

Yes, there's another column which links these two tables. I just gave a very simplied example but thanks for

pointing this out.

Then the answer will depend on the link between the two tables. A simplified example might not give the same answer as your real data then.