topic Re: How to solve this? in QlikView

How to solve this?

Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to solve this?

sunny_talwar — Wed, 20 Apr 2016 11:34:06 GMT

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

Re: How to solve this?

Thu, 21 Apr 2016 06:48:41 GMT

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

Re: How to solve this?

sunny_talwar — Thu, 21 Apr 2016 15:04:57 GMT

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';