topic Re: How to give combine heading to 2 columns in Straight table? in QlikView

How to give combine heading to 2 columns in Straight table?

Shubham_Deshmukh — Fri, 06 Oct 2017 09:46:54 GMT

I am using straight table & I just want to give name to combine 2 columns.Pls help.

Re: How to give combine heading to 2 columns in Straight table?

Anil_Babu_Samineni — Fri, 06 Oct 2017 10:11:41 GMT

In your image, I am not seeing any difficult. What you are doing

Re: How to give combine heading to 2 columns in Straight table?

Shubham_Deshmukh — Fri, 06 Oct 2017 10:17:57 GMT

But how to do it

Re: How to give combine heading to 2 columns in Straight table?

Anil_Babu_Samineni — Fri, 06 Oct 2017 10:26:22 GMT

Go for pivot table

Re: How to give combine heading to 2 columns in Straight table?

sunny_talwar — Fri, 06 Oct 2017 11:17:20 GMT

What is the reason for sticking with Straight table? Can you use Pivot table instead?

Re: How to give combine heading to 2 columns in Straight table?

prma7799 — Fri, 06 Oct 2017 11:23:01 GMT

Use Pivot table

With two dimension

Say,

Name

Month

and drag Month to over your expression.

Thanks

Re: How to give combine heading to 2 columns in Straight table?

Shubham_Deshmukh — Fri, 06 Oct 2017 11:30:10 GMT

I can do it , but my upper heading and lower heading both are static.They are labels for expression.

Actually Apr,May is not directly coming from script.Consider,

Re: How to give combine heading to 2 columns in Straight table?

Shubham_Deshmukh — Fri, 06 Oct 2017 11:30:42 GMT

I can do it , but my upper heading and lower heading both are static.They are labels for expression.

Actually Apr,May is not directly coming from script.Consider,

Re: How to give combine heading to 2 columns in Straight table?

sunny_talwar — Fri, 06 Oct 2017 11:32:47 GMT

It might be easier to see this with a simple sample data... cause from what I am seeing, it still seems like pivot table should be able to get this done... unless I am missing something.... the missing part can be explained by some data

Re: How to give combine heading to 2 columns in Straight table?

prma7799 — Fri, 06 Oct 2017 11:33:49 GMT

Please share some sample app.

Re: How to give combine heading to 2 columns in Straight table?

Shubham_Deshmukh — Fri, 06 Oct 2017 11:57:14 GMT

See,Location is my dimension.

And I have different expression(Any Name1(CY),..,..,..) for each column.

Now simply I want to show that my (Any Name1(CY),..,..,..) comes under ABC,XYZ.

(Any Name1(CY),..,..,..) , ABC, XYZ are just simple names.

Re: How to give combine heading to 2 columns in Straight table?

sunny_talwar — Fri, 06 Oct 2017 11:59:02 GMT

Can be still done in pivot table....

Pivot problem for adding another dimension | Qlik Community

Qlikview Pivot Chart with new dimension and expression

Percentage Subtotal‌

Percent of Total in Pivot Table

Re: How to give combine heading to 2 columns in Straight table?

avinashelite — Fri, 06 Oct 2017 12:06:41 GMT

Exact representation in straight table is not possible , if the columns i.e. expression are completely static then only way to achieve is to add two text with the required labels and place it on the straight table not a good option to deal but just to achieve the requirement