Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Creating tables with multpile columns

Hi,

Does Qlik Sense allow data in a tabular format where there are multiple columns that do not nest? Currently, the way I am trying gives me nested columns if I use Pivot table.

What I am looking for is attached in an image.

Thanks,

Malvika

6 Replies
undergrinder
Valued Contributor II

Re: Creating tables with multpile columns

Hi Malvika,

Is the table object suit for your requirement?

2016-02-15 18_42_04-Qlik Sense Desktop.png

G.

Re: Creating tables with multpile columns

That requires a pivot table. A simple table can have only one header, not two like your screenshot.


talk is cheap, supply exceeds demand
undergrinder
Valued Contributor II

Re: Creating tables with multpile columns

Hi Gysbert,

Where do you see the screenshot? I don't see any screenshot.

G.

Not applicable

Re: Creating tables with multpile columns

The problem with Pivot is that it is nesting the multiple columns one below the other. Any way around that?

Not applicable

Re: Creating tables with multpile columns

hi Malvika,

Make use of Pivot Table and Add Dimension as Rows/Column as per Your Output

Regards,

Tyson

Re: Creating tables with multpile columns

Use a straight table with expressions for each column and use text boxes to create the headers you want.


talk is cheap, supply exceeds demand