Key Fields and Frequencies?

[alexdataiq]

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.

[maxgro · Accepted solution]

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"?

Z:

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

];

[albertovarela]

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

[alexdataiq]

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

[alexdataiq]

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

LOAD

    Key

    Key as NewKey

...

[albertovarela]

That's right.