topic Re: need help on Cross table? in QlikView

need help on Cross table?

Wed, 04 Feb 2015 15:52:55 GMT

Hi Folks,

I am unable to create a cross table...plwease need help on this.

I have source table in below crosstable.xls(sheet1)

i need the data like crosstable.xls(sheet2) for all the ID and Name's?

Here i have Null data in sla3,sal4,sal5,sal6 but i want those data also in my cross table outpiut.

Re: need help on Cross table?

rubenmarin — Wed, 04 Feb 2015 15:57:41 GMT

Hi Rakesh, this script works for me:

CrossTable(Type, Data, 2)

LOAD Id,

Name,

sal1,

sal2,

sal3,

sal4,

sal5,

sal6

FROM

[.\Croos Table.xlsx]

(ooxml, embedded labels, table is Sheet1);

Re: need help on Cross table?

Wed, 04 Feb 2015 16:01:31 GMT

Tyou but here it's not giving all the values in type(like sal1,sal2,sal3,sal4,sal5,sal6) which i have here

Re: need help on Cross table?

rubenmarin — Wed, 04 Feb 2015 16:05:40 GMT

Sorry, I don't understand the requirements, this is what I get:

What you need?

Re: need help on Cross table?

Anonymous — Wed, 04 Feb 2015 16:08:35 GMT

Hi Rakesh:

Please see the app attached. I have achieved what you wanted exactly, data with null values.

Hope it helps, let me know.

Good luck!

Re: need help on Cross table?

sandeep_sarawgi — Tue, 14 Apr 2015 18:08:46 GMT

I had a similar problem and here is what I did to solve it.

First, I added

SET NullValue = '<Unspecified>' //this was added in the Main tab of the script

NullAsValue *; // for handling nulls as a string <Unspecified>

Then, I first loaded the data from source into a QV table

Tmp:

Load *

From

..... //what ever your data source is

Finally, I performed the cross-table load:

CrossFacts:

Crosstable(Metric,Value, 5)

Load *

Resident Tmp;

Drop Table Tmp;