topic Re: Create a dimension in script for every field in QlikView

Create a dimension in script for every field

markgraham123 — Tue, 16 Aug 2016 18:12:47 GMT

Hi All,

I'm trying to create an individual name in a dimension for every field.

Here is the Example:

Product A Units	Product B Units	Product C Units	Product D Units
100	200	300	400

I'm trying to create a new dimension which would have names of the Product mapped to its units value.

New Dimension

Product A Units A

Product B Units B

Product C Units C

Product D Units D

I did it in the front end using Value list , Pick Match.

But i'm trying to do it in script so it can be simple on front end chart.

Any help is highly appreciated.

Re: Create a dimension in script for every field

sunny_talwar — Tue, 16 Aug 2016 18:16:38 GMT

Try something like this:

Test:

CrossTable(Dimension, Value)

LOAD RowNo() as Key,

LOAD * Inline

[

Product A Units, Product B Units, Product C Units, Product D Units

100,200,300,400

];

Re: Create a dimension in script for every field

swuehl — Tue, 16 Aug 2016 18:17:06 GMT

Maybe use

The Crosstable Load

to transform your table, then you can extract your Unit e.g. using

Subfield(FIELDNAME,' ',2) as Unit

Re: Create a dimension in script for every field

markgraham123 — Tue, 16 Aug 2016 18:20:09 GMT

Sunny,

Do we have any field count limitations to use cross table?

Re: Create a dimension in script for every field

sunny_talwar — Tue, 16 Aug 2016 18:21:54 GMT

field count limitation? Not sure what you mean? can you elaborate?

Re: Create a dimension in script for every field

markgraham123 — Tue, 16 Aug 2016 18:22:59 GMT

Stefan,

I'm new to the advanced concepts of data manipulation.

I really do not understand if u just give a keyword.

Anyways thanks.

Re: Create a dimension in script for every field

markgraham123 — Tue, 16 Aug 2016 18:23:54 GMT

Like we have 2 field limitation to use Apply map.

Re: Create a dimension in script for every field

sunny_talwar — Tue, 16 Aug 2016 18:27:00 GMT

I guess you need at least 2 fields for CrossTable to work. Cannot work if you just have 1 field.

Re: Create a dimension in script for every field

markgraham123 — Tue, 16 Aug 2016 18:28:16 GMT

Got it.

Thank you Sunny

Re: Create a dimension in script for every field

markgraham123 — Tue, 16 Aug 2016 18:32:06 GMT

Sunny,

Is there a chance to rename Dimension and values as other names at a time with Crosstable??

I know we can do it by loading resident in another table.

But just checking

Re: Create a dimension in script for every field

swuehl — Tue, 16 Aug 2016 18:36:16 GMT

Hi Mark,

the concept is explained in detail in the referenced blog post by Henric.

You cannot use a preceding LOAD or LOAD prefix on top of the CROSSTABLE LOAD, so you would need to use a subsequent RESIDENT LOAD for further transformations or field manipulations.