Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is it possible to visualize the data in Pivot/Table in Qlik Sense like we are able to do in Excel in a table format with multiple columns without nesting?
ID | Age | Gender | Weight | Height |
---|---|---|---|---|
When i tried Pivot table in Qlik Sense, it nested the column variables one below the other. Is there a way to work around that?
Thanks
Hi Malvika,
Could you share an example of your pivot, that you doesn't like?
On the picture I can only see a straight table, that you can make easily in Qlik Sense, just drop the table object onto the sheet.
You can make a table with drill-down dimension to avoid a Pivot.
Example: Drill-down dimension = Gender -> Age ->ID
The height and weight will be the measures.
Before drill-down:
Gender avg(height) avg(weight)
M 178 80
F 177 55
After drill-down (M selected):
Age avg(height) avg(weight)
21-25 179 81
26-30 177 79
31-35 178 80
G.
If what you want is the table not to collapse the fields you need to select fully expanded in the settings
if you select
you will get
rather than
Hi,
Instead of Pivot table you can use normal table object for this.
Regards,
jagan.
Instead of Pivot try Simple table, where
Dim: ID, Age, Gender
Expression: Wright , Height
I think it should work!!
Thanks Bella, but this would nest one column below the other, what i am looking for is separate columns for each variable and not nesting (as shown below) . Any way around that?
Hi Malvika,
You will have to go with a straight table to achieve this.
Thanks,
Sangram.
Hi Malvika,
You can useTable Object and you put dimension and measurement there.
Regards,
Marco