Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Using Columns Headers as Dimensions

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 PartyArrival StatusS/O Item(A)TAT1_Line itemsTAT2_Line itemsTAT3_Line itemsTAT5_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!

1 Solution

Accepted Solutions
Not applicable
Author

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

reagrds

Darek

View solution in original post

3 Replies
Not applicable
Author

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

reagrds

Darek

sasikanth
Master
Master

HI

Can you provide you DB table clearly ,,,,

Anonymous
Not applicable
Author

Thank you very much!

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

Thank you!