topic Re: Abnout only and mode function in QlikView

Abnout only and mode function

Sat, 22 Dec 2012 02:55:54 GMT

Hi ALl,

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

Can you give me an example?

Thanks.

Re: Abnout only and mode function

Gysbert_Wassenaar — Sat, 22 Dec 2012 10:12:50 GMT

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

T1:

load * Inline [

ID, Age

123, 12

123, 28

145, 30

165, 15

165, 17

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.

Re: Abnout only and mode function

Nagaraju_KCS — Wed, 27 Feb 2013 15:24:05 GMT

Hi Gysbert

T1:

load * Inline [

ID, Age

123, 12

123, 28

145, 30

165, 15

165, 17

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..