topic Re: How to get the data. in QlikView

How to get the data.

abc_18 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am having two table.

In one table I have information about the students like

student ID, Age,Class,Name

and another table I am having only student ID of those student who has failed.

now my question is how to get data about those students who has passed the examination.

Re: How to get the data.

aarkay29 — Tue, 20 Jun 2017 14:15:21 GMT

May be this

//From Students Failed Table

Failed :

load StudentID as StudentID_Failed

From Students Failed;

//From Students Info table

Passsed:

Load StudentID as

From Students

Where Not Exists(StudentID_Failed);

Re: How to get the data.

prat1507 — Tue, 20 Jun 2017 14:17:15 GMT

TablePassed:

Load From Table1

Where Not Match(Customer, 'A','B','C');

TablefAIL:

Load * Inline [

Student Id

101

102

];

Table1:

Load * Inline [

Student Id, Age, Class, Name

101, 1,1,A

102, 1,2,B

202, 2,2,C

200, 2,2,D

201, 2,1,E

] where not Exists(Student Id);

Re: How to get the data.

el_aprendiz111 — Tue, 20 Jun 2017 14:36:33 GMT

Hi,

DATA:
LOAD * Inline
[
student ID, Age,Class,Name
1,11,M,AZ
2,12,N,QSC
3,10,H,WDV
4,13,J,EFB
5,9 ,O,RGN
];

DATA2:
LOAD * Inline
[
student ID
3
4
];

ID:
LOAD Concat(DISTINCT [student ID],',') AS stdID Resident DATA2;
LET vStudentId = Peek('stdID');

SUMARY:
LOAD *, RecNo() AS ID Resident DATA Where not Match([student ID],$(vStudentId));

DROP Table ID, DATA, DATA2;

Age	Class	Name	student ID
11	M	AZ	1
12	N	QSC	2
9	O	RGN	5