Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Valued Contributor II

Re: Visualizing the data as in Excel

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.

bellamae
Valued Contributor

Re: Visualizing the data as in Excel

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

MVP
MVP

Re: Visualizing the data as in Excel

Hi,

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

Regards,

jagan.

balrajahlawat
Esteemed Contributor

Re: Visualizing the data as in Excel

Instead of Pivot try Simple table, where

Dim:  ID, Age, Gender

Expression: Wright , Height

I think it should work!!

Not applicable

Re: Visualizing the data as in Excel

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

reddys310
Honored Contributor II

Re: Visualizing the data as in Excel

Hi Malvika,

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

Thanks,

Sangram.

chooco_co
Valued Contributor

Re: Visualizing the data as in Excel

Hi Malvika,

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

table.png

Regards,

Marco

Community Browser