Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Certification Exam Sale - 40% off. Register by June 30, 2020. GET DETAILS
Highlighted
New Contributor III

Load ONLY one example

How do I go about loading just 1 example from a list of many? I need something like

Load

Example as [This Example]

From [etc.]

where Example = 'Example1'

and blah = 'example2' and 'example3'

etc.

I just want the table to say-

This Example

     Example1

Tags (1)
6 Replies
Highlighted
Esteemed Contributor III

Re: Load ONLY one example

Not sure we quite understood your query.. May be this?

Load

Example as [This Example]

From yoursource

where Example = 'Example1' ;

Highlighted

Re: Load ONLY one example

First N limits the load to only N rows.  This only affects the load that follows, other tables will be fully loaded.

First 1

Load

Example as [This Example]

From [etc.]

where Example = 'Example1'

and blah = 'example2' and 'example3'

Highlighted
New Contributor III

Re: Load ONLY one example

That's not working. When I put the table in and choose This Example it shows more than one example.

I want it to say this-

GMNA

     GMNA Top 5

Where both are loaded for just their own columns, such as CY 2011, CY 2012, CY 2013, CY 2014, etc. But only for GMNA or GMNA Top 5

Highlighted
Esteemed Contributor III

Re: Load ONLY one example

Sorry did not get you what you looking for can you share some sample with an expected output.

Highlighted
Honored Contributor

Re: Load ONLY one example

Nicholas,

     Are you loading from a source or a resident table? If resident table then

LOAD

Example as [This Example]

Resident TableName

where Example = 'Example1'

and blah = 'example2' and 'example3'

and RecNo() = 1;

Highlighted
New Contributor III

Re: Load ONLY one example

Here's an example of what I want.

Example of GMNA.png