Separate Data Sources for Each Sheet

[#1]

Hello Community,

I've tried searching for an answer on this topic with no luck as of yet.

I am creating a Qlikview document with 3 sheets, each of which will have a chart on it.  I would like each sheet to pull its data from a single excel document.  The Excel document has 3 sheets, each with the same name as its corresponding Qlikview tab.  How can I achieve this data connection?

I'm a Qlikview novice, so please bear with me!  Thanks for your assistance.

[martynlloyd]

Hi,

Use the file wizard, from menu - Insert, Load Statement, Load from File

regards,

Marty.

[#3]

Marty - Thanks for you reply.  I was able to add an additional dataset, but it appears Qlikview has added that data to the prior sheet's dataset.  There are some common fields between each dataset, but they should be kept separate.  How do I tell Qlikview to treat them separately?

[martynlloyd]

Hi Greg,

Use NoConcatenate before the subsequent load statements:

NoConcatenate

Working with QlikView > Script Syntax and Chart Functions > Script statements and keywords > Script ...

The NoConcatenate prefix forces two loaded tables with identical field sets to be treated as two separate internal tables, when they would otherwise be automatically concatenated. Syntax: NoConcatenate( loadstatement | selectstatement ) Example: LOAD A,B from file1.csv; NoConcatenate LOAD A,B from...

Regards,

Marty.

[martynlloyd]

You may want to consider renaming the fields with AS

It depends if you are going to drop the tables or not when you have processed them...

[Anonymous]

Hi,

After loading your 3exel sheets in to script,

you can use the no concatenation statement in between these tables....after this, when ever you going to reloading it is going to show some synthetic keys,

but you don't worry about the synthetic keys in this situation.

then

you can create qlikview document with 3sheets,

and

use the single table in single sheet to create your objects.

[martynlloyd · Accepted solution]

Hi Greg,

A better option would be to create a field to filter by sheet -

Load

'Sheet1' as Source,

...

From..

Concatenate

Load

'Sheet2' as Source,

...

That way you avoid the joins, and you can use set analysis to filter by sheet

Marty.