Abnout only and mode function

[#1]

Hi ALl,

May I know what is the difference between only and mode function?

Can you give me an example?

Thanks.

[Gysbert_Wassenaar · Accepted solution]

Create a new qlikview document and put this in the load script:

T1:

load * Inline [

ID,    Age

123,    12

123,    28

145,    30

145,    30

165,    15

165,    17

165,    15

165,    15

165,    12

165,    18

];

T2:

load ID, mode(Age) as AgeMode, only(Age) as AgeOnly

Resident T1 Group by ID;

Save the document and click on Reload. Create two table boxes for T1 and T2. Compare the values in the two tables. You'll see the difference in T2 between what Only and Mode do.

[qv_testing]

Hi Gysbert

T1:

load * Inline [

ID,    Age

123,    12

123,    28

145,    30

145,    30

165,    15

165,    17

165,    15

165,    15

165,    12

165,    18

];

T2:

load ID, mode(Age) as AgeMode, only(Age) as AgeOnly

Resident T1 Group by ID;

T2 table  Returns

ID, AgeMode, AgeOnly

123,-,-

145,30,30

165,15,-

but i didn't understand..

please explain it..