Using Columns Headers as Dimensions

Anonymous — Wed, 28 May 2014 12:59:36 GMT

Hello community,

I am new to the community and I'm amazed with this software.
I've been trying to create a simple graph where the dimensions are the Column Headers.

I know that this isn't the best way to do this, but the DB is formatted like this...

For example:

Ship-To Party

Arrival Status

S/O Item(A)

TAT1_Line items

TAT2_Line items

TAT3_Line items

TAT5_Line items

I have under Ship-to Party a couple of Vendors and 3 different status under Arrival Status.

The S/O Item(A) is the sales category and under the TAT Line Items are the arrival quantities in 1, 2, 3, and 5 days.

I'd like to see the progression of the arrival quantities in the different days in a graph, where the dimensions would be the TAT lines (Column Headers) and the DATA would be the sum of quantities these columns.

What should I put in Dimensions and Expressions?

Thank you very much for the support!

Re: Using Columns Headers as Dimensions

Wed, 28 May 2014 13:28:33 GMT

maybe you will like to use crosstable() in your load script.

reagrds

Darek

Re: Using Columns Headers as Dimensions

sasikanth — Wed, 28 May 2014 14:18:11 GMT

Can you provide you DB table clearly ,,,,

Re: Using Columns Headers as Dimensions

Anonymous — Thu, 29 May 2014 14:52:38 GMT

Thank you very much!

I am new to the software and I'm doing some tutorials trying to learn new things!

Thank you!

topic Re: Using Columns Headers as Dimensions in QlikView

Using Columns Headers as Dimensions

Re: Using Columns Headers as Dimensions

Re: Using Columns Headers as Dimensions

Re: Using Columns Headers as Dimensions