Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Could you please attach a sample file
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...
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
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?
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.
Ok, my edited post is now online.