topic Re: Key Fields and Frequencies? in QlikView

Key Fields and Frequencies?

alexdataiq — Tue, 19 Jan 2016 17:59:18 GMT

Hi,

I'm pretty sure this has been aswered before, but I couldn't find the relevant post/info. What's the rationale behind QV not allowing to display the frequencies of the Key Fields? What's the technical reason for this?

If someone could shed some light on this or point me out to the relevant part in the documentation It would be really appreciated.

Regards.

Re: Key Fields and Frequencies?

maxgro — Tue, 19 Jan 2016 18:42:00 GMT

I think because a key is used to associate 2 (or more) tables and you cannot show the frequency for many tables

which is the frequency of the field "a"?

load * inline [

dim1, dim2

a,11

b,2

a,33

c,444

];

ZZ:

load * inline [

dim1, dim3

a,11

b,2

c,333

c,444

];

Re: Key Fields and Frequencies?

albertovarela — Tue, 19 Jan 2016 18:46:00 GMT

Qlik has a problem knowing which of the tables it should use for calculating the frequency. The workaround for this is to load the field one more time but with new name, then you can display freq on this new field

Re: Key Fields and Frequencies?

alexdataiq — Tue, 19 Jan 2016 18:46:00 GMT

Well, that sounds really logic. I don't know why I didn't think of that before!

Re: Key Fields and Frequencies?

alexdataiq — Tue, 19 Jan 2016 18:48:55 GMT

OK. Do you mean loading it a second time in the Script?

LOAD

Key

Key as NewKey

...

Re: Key Fields and Frequencies?

albertovarela — Tue, 19 Jan 2016 19:13:19 GMT

That's right.