topic Re: Count function on Primary key in QlikView

Count function on Primary key

Tue, 10 Apr 2012 03:44:52 GMT

I can not allow to use count function on Primary key but if i rename it then i can use count function on that primary key......how it is possible????

yojas

Count function on Primary key

Tue, 10 Apr 2012 04:28:33 GMT

Hi,

Count is an aggregation function and to use any aggregation function (in load script), you will need to aggregate it on the basis of other fields you are loading in parallel.

If this is the only statement then it will work without group by also.

Can you please share your app or load statement where you are having issue?

Ashutosh

Count function on Primary key

Tue, 10 Apr 2012 05:53:36 GMT

hi,

actually i read somewhere that we can not apply count function on primary key....but i donk know why it is so??

yojas

Count function on Primary key

Tue, 10 Apr 2012 06:02:58 GMT

Yeah,

I also have some blurred memory of reading it somewhere but I was not able to recall it or find the source where I read it.

So, I tried to use it on a link field in Qlikview and it worked fine for me. So, I was not able to reach on any justification.

That is the reason, i had said to you to share the app or load statement where it was not working for you.

That way, I will be able to conclude if it works or not.

Ashutosh

Count function on Primary key

Tue, 10 Apr 2012 06:03:38 GMT

and yes we can not show frequencies of the link fields in list box.

Count function on Primary key

Tue, 10 Apr 2012 06:07:57 GMT

or may be in that post it would have been refering to count of values shown in document properties under the tables tab where if any field is a key field then it shows the count of values 0 for that field.

because, I tried count function in front end also on key field and it works.

Ashutosh

Count function on Primary key

Tue, 10 Apr 2012 06:10:47 GMT

what are the link fields in list box? Is it a key which is primary key of 1 table and foreign key of other table?and if it is that key then we can show frequencies over there.......

yojas

Re: Count function on Primary key

Tue, 10 Apr 2012 06:20:39 GMT

Hi Yojas,

In Qlikview there are no primary or foreign keys, there are only keys.

Key field is a field which is present in more than one table so, it works as a link between those tables, so sometimes is also referred as link field.

when you take any field in list box and go to the list box properties -> general then there will be a check box for show frequency which will only be available for the non key fields.

Ashutosh

Count function on Primary key

Tue, 10 Apr 2012 06:58:31 GMT

i understand what you want to say and i tried to apply that option for key fields and it is showing me frequencies of that field......

Count function on Primary key

Tue, 10 Apr 2012 07:23:36 GMT

I don't think that you can see frequencies of the key fields.

You may be seeing it for some non key field, please recheck it.

Count function on Primary key

Tue, 10 Apr 2012 07:29:56 GMT

yes i am getting it for all types of fields.....

Count function on Primary key

Tue, 10 Apr 2012 08:37:48 GMT

Hi,

From key fields, I am refering to the fields which are key field in your Qlikview data model, I am not saying about fields which were key fields in your source database!!

Can you post me a screenshot of your table viewer (ctrl+T) which shows that a field is link field and also a list box showing frequencies for that link field?

That will be a good learning for me because till now I used to believe that link fields don't show frequency.

Re: Count function on Primary key

Fri, 20 Apr 2012 09:00:30 GMT

Hi Ashutosh,

I am sending you snapshots in which Customer_ID is primary key and still showing frequencies...but in some examples we can not apply show Frequencies for primary key... because it is desabled... i dont understand why this is happening?

yojas

Re: Count function on Primary key

Fri, 20 Apr 2012 09:25:41 GMT

Hi Yojas,

I am not able to see the image you have uploaded, can you please check it again if you are able to see it.

I have always seen show frequency option disabled for associating fields (Key Fields).

Qlikview explains that there could be ambiguity when field is in different tables.

However, There may be something missing which I have never seen because there are some behaviors in Qlikview which are not documented.

So, please share the image again, or if possible share the application (will help me to catch whole scenario).

Thanks!

Ashutosh

Re: Count function on Primary key

Fri, 20 Apr 2012 09:33:43 GMT

Hi,

i sorry i don't speak english very but i want to gives my view. It is not possible to use the function count on Primary Key in Qlikview. You can use count on another field of a table but not on the Primary Key, do not forget it.

Re: Count function on Primary key

Fri, 20 Apr 2012 09:47:34 GMT

Hi,

But we can use count on primary key....

e.g. : if my table contains Order_Id as primary key then using count(Order_Id) i can get number of orders.

yojas

Count function on Primary key

Fri, 20 Apr 2012 09:53:22 GMT

Sorry.... but the print screen is not coming clear....

yojas

Count function on Primary key

Fri, 20 Apr 2012 09:57:33 GMT

Hi,

As per reference manual version 10 page no. (book 1 pg 472) (you can search using 'Frequencies'),

it is written that count function can not be used on the key fields (associating fields). While, I have seen that in some scenrios it works, so it is basically based on the ambiguity if it exists then this function will not work or else it works.

But, showing frequencies, I have never seen to work on key fields.

Ashutosh

Count function on Primary key

Fri, 20 Apr 2012 09:58:11 GMT

okay, but can't you attach the app?

Count function on Primary key

Fri, 20 Apr 2012 10:08:57 GMT

I am not able to send my QlikView application ...in the attachment it is asking only for Web URL....