How to solve this?

[#1]

Hi!

I'm relatively new to QlikView, and I'd like to accomplish a task.

I have a table in the format

Name	Course
A	Math101
B	Science101
C	Physics101
D	All

As you can see from the above data, it contains names of persons who have registered for specific course, expect D.

So, when I query for students of Math101, I get student A, which is right. But, I'd also like to see D's name appear in the selection.

Does Qlik provide a function, to handle these cases?

TIA!

Regards

Sivakumar Kumar

[sunny_talwar · Accepted solution]

May be add an Inline Table like this:

LOAD * INLINE [

Course, CourseSelection

Math101, Math101

Science101, Science101

Physics101, Physics101

All, Math101

All, Science101

All, Physics101

];

Now make selections in CourseSelections rather than Course field

[#3]

Hi Sunny!

For a small table this is certainly helpful. When the table size grows and new courses get added, I'd have to append All with new Courses. Any suggestions to overcome that situation?

Or, maybe I should I have one more column called, ALL, for all rows. What do you suggest?

//Siva

[sunny_talwar]

What about this:

SelectionTable:

LOAD Course,

          Course as CourseSelection

Resident Table

Where Course <> 'All';

Concatenate(SelectionTable)

LOAD 'All' as Course,

Course as CourseSelection

Resident Table

Where Course <> 'ALL';