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,

[avinashelite]

could you share the sample data file ..lets check

[qlikview979]

Your condition is working fine in my sample data also,but in my dashboard when i use this condition its not getting correct result.

i don't know why its not working

[qlikview979]

Due to security reasons i am not able to share data file.

[avinashelite]

Create mock up data for this and share with us

[qlikview979]

Hi All,

I  am  sharing mock up data  in pivot table , what ever i highlighted with yellow color,i want to remove that unique data  from my table.

First sheet :- Mock up data

Second sheet :- Expected output

this expression i am using

=if(len(trim([Date Trained])) = 0, COUNT({<[Event Status]-={'DROPPED','HOLD','CANCEL'},

[Event Type]={'SPKRPGM'},[Site Participant Attendance Status]={'ACCEPTED','ATTENDED'}>}[Event ID]))

regards

Mahesh

[qlikview979]

Hi All,

please check my attached file and help me on this.

Regards

Mahesh

[qlikview979]

stalwar1‌kush141087‌loveisfail‌swuehl‌

[vishsaggi]

Few clarifications.

- Event Type, Date Trained, Site Participant Attendance Status where are these fields in your excel sheet.

- Your expected output show N, O, P, Q, R values fro Speaker Name, why M should not be considered any criteria for that?

- You have few expressions used where we cant see the field names used in those expression. Do we have to use these expressions too to recreated in Qlik or just use only fields without any expressions?

[qlikview979]

Sorry bro,i  am sharing new Mock up file

PFA

[qlikview979]

can any one help  me on this?