topic Re: Separate Data Sources for Each Sheet in QlikView

Separate Data Sources for Each Sheet

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Separate Data Sources for Each Sheet

martynlloyd — Thu, 15 Dec 2016 16:22:50 GMT

Hi,

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

regards,

Marty.

Re: Separate Data Sources for Each Sheet

Thu, 15 Dec 2016 19:13:22 GMT

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?

Re: Separate Data Sources for Each Sheet

martynlloyd — Fri, 16 Dec 2016 12:30:24 GMT

Hi Greg,

Use NoConcatenate before the subsequent load statements:

NoConcatenate

Working with QlikView > Script Syntax and Chart Functions > Script statements and keywords > Script prefixes > NoConcatenate

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.

Re: Separate Data Sources for Each Sheet

martynlloyd — Fri, 16 Dec 2016 12:33:21 GMT

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...

Re: Separate Data Sources for Each Sheet

Anonymous — Fri, 16 Dec 2016 13:02:06 GMT

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.

Re: Separate Data Sources for Each Sheet

martynlloyd — Fri, 16 Dec 2016 13:11:48 GMT

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.