Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
njreardo
Contributor III
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

6 Replies
vishsaggi
Champion III
Champion III

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

Load

Example as [This Example]

From yoursource

where Example = 'Example1' ;

Colin-Albert

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'

njreardo
Contributor III
Contributor III
Author

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

vishsaggi
Champion III
Champion III

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

effinty2112
Master
Master

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;

njreardo
Contributor III
Contributor III
Author

Here's an example of what I want.

Example of GMNA.png