Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Visualizing the data as in Excel

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?

IDAgeGenderWeightHeight

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

7 Replies
undergrinder
Specialist II
Specialist II

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.

Anonymous
Not applicable
Author

If what you want is the table not to collapse the fields you need to select fully expanded in the settings

if you select

Capture4.PNG

you will get

Capture3.PNG

rather than

Capture5.PNG

jagan
Luminary Alumni
Luminary Alumni

Hi,

Instead of Pivot table you can use normal table object for this. 

Regards,

jagan.

Anonymous
Not applicable
Author

Instead of Pivot try Simple table, where

Dim:  ID, Age, Gender

Expression: Wright , Height

I think it should work!!

Not applicable
Author

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?

Capture.PNG

reddy-s
Master II
Master II

Hi Malvika,

You will have to go with a straight table to achieve this.

Thanks,

Sangram.

marcohadiyanto
Partner - Specialist
Partner - Specialist

Hi Malvika,

You can useTable Object and you put dimension and measurement there.

table.png

Regards,

Marco