Pivot table with two columns on the left

[QlikSensor]

Hi, we are used to ît from Excel: Having two columns on the left before the Pivot table starts.

There is a 1:1 relationship between two columns of my raw table. Let's say the first column is a unique number of a database and the second column is a unique descriptive field of that unique number. I want to show both columns right next to each other before the actual pivoting starts. I only managed in QlikSense to introduce the descriptive field as a dimension which leads to having the number field and the descriptive field below if I expand the number field (and even more worse I get two lines in the resulting pivot table).

I am wondering if it's possible to show the descriptive field right next to that number field?

[Vegar]

The syntax is 

crosstable (attribute field name, data field name [ , n ] ) ( loadstatement | selectstatement )

Imagine you have this data:

ID	Desc	Jan	Feb	Mar	Apr	May	Jun
A	Adam	45	65	78	12	78	22
B	Betty	11	23	22	22	45	85
C	Caesar	65	56	22	79	12	56
D	David	45	24	32	78	55	15
E	Emmy	45	56	35	78	68	82
F	Farhan	57	77	90	24	90	34
G	Gino	23	35	34	34	57	97
H	Hassan	77	68	34	91	24	68
I	Ida	57	36	44	90	67	27
J	Jesus	57	68	47	90	80	94

Then you could crosstable this data with the following statement:

crosstable (Month, Amount, 2) LOAD * from DataSource;

Read more on the Crosstable here: Crosstable - Qlik Sense

[anushree1]

Could you please attach a sample file

[anushree1]

Could you please attach a sample file

[Vegar]

Please find attached Qlik Sense application

[QlikSensor]

Hm, as I can see you have created the Pivoting during reading the data and didn't use the Pivot-diagram but used a usual table. Am I right? Furthermore I can see that you already read in a pivot table. I am even more confused. This don't looks like that it solves my problem at least I can't see the solution...

[QlikSensor]

Maybe I post an example table I read:

Unique Number       Unique Name      Month

0                                        Zero                          Jan

1                                        One                           Feb

2                                        Two                           Jan

0                                        Zero                           Jan

1                                        One                            Feb

2                                        Two                            Feb

This is the table I would like to create:

Unique Number    Unique Name               Jan       Feb

0                                     Zero                                 2             0

1                                     One                                  0             2

2                                     Two                                  1             1

What I get if I make Unique Name as a further dimension:

Unique Number/Unique Name           Jan    Feb

0                                                                         2          0

Zero                                                                  2          0

1                                                                         0          2

One                                                                   0          2

2                                                                         1          1

Two                                                                   1          1

[Vegar]

I'm also a bit confused 😕

You need help presenting data in a pivot table object in Qlik Sense?

How does your data look like inside Qlik Sense? Like the input or output of the data in my previous attached Qlik Sense  application? Could you provide a sample app/picture/description?

Do you need help in loading the data to fit your need or is ist only front end support for the use of pivot table object you are lookin for?

[QlikSensor]

I did attach an example in my last post (unfortunately I edited the post and it says, it's visible after moderation 😞 Please wait some time until the example is visible. Sorry for the delay.

[QlikSensor]

Ok, my edited post is now online.