Association in straight table

[qlikview979]

Hi All,

My data like

LOAD * Inline [

ID,NAME,TECHNOLOGY

100,A,Qlikview

200,B,Informatica

300,A,Qliksense

400,D,Java

500,D,Drupul

600,E,Qliksense

700,B,Oracle

];

like this i have 5000 rows of data i have .

here i need who are associated with multiple technologies.

Dim:-NAME,TECHNOLOGY

Exp:-Count(ID)

Exp O/P:-

NAME,TECHNOLOGY

A,Qlikview,

A,Qliksense,

D,Java,

D,Drupul,

B,Oracle,

B,Informatica,

[qlikview979]

how can i write  calculation dimension in dimension level for this

[big_dreams]

Hi,

take table box

add Name & Technology.

Regards,

[big_dreams]

What do you want to achieve.

can you explain in details??

Regards,

[Mark_Little]

Hi,

Your calculations should be something like

IF(Count(ID)>1,Name)

Mark

[Anil_Babu_Samineni]

May be this?

Count({<NAME = {"=Count(TOTAL <NAME> ID)>1"}>} TOTAL <NAME> ID)

OR

Count({<NAME = {"=Count(TOTAL <NAME> ID)>1"}>} ID)

OR, This is dimension

=If(Aggr(Count({<NAME = {"=Count(TOTAL <NAME> ID)>1"}>} ID), NAME), NAME)

[Anil_Babu_Samineni]

Make sure, To use Suppress for that

[avinashelite]

try like this in the expression that should also work

if(count(ID)>1,Count(ID))

in the dimension

if(Aggr(Count(ID),NAME)>1,NAME)

[qlikview979]

I tried all Conditions not working,

even

my condition is working in sample data  =Aggr(if(count(NAME)>=2,NAME),NAME)

But not working in final table.

[Anil_Babu_Samineni]

What you mean by final table? Seems working