Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
could you share the sample data file ..lets check
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
Due to security reasons i am not able to share data file.
Create mock up data for this and share with us
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
Hi All,
please check my attached file and help me on this.
Regards
Mahesh
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?
Sorry bro,i am sharing new Mock up file
PFA
can any one help me on this?