Visualizing the data as in Excel

[#1]

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

[undergrinder]

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]

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

[jagan]

Hi,

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

Regards,

jagan.

[Anonymous]

Instead of Pivot try Simple table, where

Dim:  ID, Age, Gender

Expression: Wright , Height

I think it should work!!

[#6]

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?

[reddy-s]

Hi Malvika,

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

Thanks,

Sangram.

[marcohadiyanto]

Hi Malvika,

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

Regards,

Marco