topic Re: Load ONLY one example in QlikView

Load ONLY one example

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

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

Re: Load ONLY one example

vishsaggi — Fri, 11 Aug 2017 14:21:35 GMT

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

Load

Example as [This Example]

From yoursource

where Example = 'Example1' ;

Re: Load ONLY one example

Colin-Albert — Fri, 11 Aug 2017 14:24:18 GMT

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'

Re: Load ONLY one example

Anonymous — Fri, 11 Aug 2017 14:29:26 GMT

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

Re: Load ONLY one example

vishsaggi — Fri, 11 Aug 2017 14:35:05 GMT

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

Re: Load ONLY one example

effinty2112 — Fri, 11 Aug 2017 14:36:29 GMT

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;

Re: Load ONLY one example

Anonymous — Fri, 11 Aug 2017 14:52:13 GMT

Here's an example of what I want.