topic Re: Pivot table column width issue or Straight table with horizontal excel export issue in QlikView

Pivot table column width issue or Straight table with horizontal excel export issue

ashok1203 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I need to display a list of measures on a timely manner in the pivot table like below.

If i use pivot table, it was taking all columns width is same. So,i am not able to display the first column width as expected. If i increase one column width automatically it was reflecting to all other columns. But i need first column width is more compare to all remaining columns. For this i tried Size to data option, Intend option and many in the properties but not able to achieve as expected.

For this, I prepared the same chart in straight table by using the Horizontal option, the required layout am able to achieve but while exporting the table into excel, the table data i am getting as transpose.

Can anyone please help me to achieve.

Thanks in Advance..!

Re: Pivot table column width issue or Straight table with horizontal excel export issue

avinashelite — Thu, 17 Aug 2017 05:56:37 GMT

as per I know its the default property of Pivot table .....in order to make one column width different then you need to make use of multiple expressions ....For the export in straight table you could make use of the macro and add a button to export as per requirement

Re: Pivot table column width issue or Straight table with horizontal excel export issue

devarasu07 — Thu, 17 Aug 2017 05:57:03 GMT

Hi,

Try to increase the word wrap text at presentation tab.

Re: Pivot table column width issue or Straight table with horizontal excel export issue

ashok1203 — Thu, 17 Aug 2017 06:03:57 GMT

Hi Devarasu,

I tried the option, again it was reflecting entire table. Need to modify only the first column width or cell.

Re: Pivot table column width issue or Straight table with horizontal excel export issue

ashok1203 — Thu, 17 Aug 2017 06:07:52 GMT

Hi Avinash,

All the first column values are different measures only.

For Straight table, can you have any macro code please provide. I tried to get it by using the other links but i am not getting it correctly.

Re: Pivot table column width issue or Straight table with horizontal excel export issue

avinashelite — Thu, 17 Aug 2017 06:13:59 GMT

could you share the sample file of the export ?

Re: Pivot table column width issue or Straight table with horizontal excel export issue

devarasu07 — Thu, 17 Aug 2017 06:28:01 GMT

Hi,

It's limitation. the best way you can word wrap like this.

Re: Pivot table column width issue or Straight table with horizontal excel export issue

ashok1203 — Thu, 17 Aug 2017 06:35:33 GMT

Hi Devarasu,

All the fields that we have in column 1 are measures. We have only one dimension Date dimension.

Re: Pivot table column width issue or Straight table with horizontal excel export issue

its_anandrjs — Thu, 17 Aug 2017 06:46:31 GMT

Hi,

You can try another way also by conditionally load the table if you required some spaces on the some columns see the example

Ex:-

Load

If( match( ColumnName,'Jan','Feb','Mar'), ' '&ColumnName, ColumnName)

From Location;

Regards,

Anand

Re: Pivot table column width issue or Straight table with horizontal excel export issue

ashok1203 — Thu, 17 Aug 2017 08:37:59 GMT

Hi Anand,

Thanks for response. Hope this method is not applicable to the scenario.

Re: Pivot table column width issue or Straight table with horizontal excel export issue

ashok1203 — Thu, 17 Aug 2017 08:38:59 GMT

Guys, is their any macro to export the report in correct format.

Re: Pivot table column width issue or Straight table with horizontal excel export issue

Frank_Hartmann — Thu, 17 Aug 2017 10:30:04 GMT

see attached file

sub ExcelExport
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = False
objExcel.DisplayAlerts = True
Set xlDoc = objExcel.Workbooks.Add
set obj = ActiveDocument.GetSheetObject("CH01")
obj.CopyTextToClipboard
objExcel.Range("A1").PasteSpecial
objExcel.Range("A1").ColumnWidth = 30
xlDoc.SaveAs "C:\Users\Admin\Desktop\Test.xlsx"
xlDoc.Close
end sub

hope this helps

Re: Pivot table column width issue or Straight table with horizontal excel export issue

ashok1203 — Thu, 17 Aug 2017 10:49:38 GMT

Hi Frank,

i am trying to export the table from the attached QVW. I am getting the below error.

Is this method will work in Access point as well. I need to export the report from the access point like we will use the excel export in charts.

Thanks

Re: Pivot table column width issue or Straight table with horizontal excel export issue

ashok1203 — Thu, 17 Aug 2017 13:51:15 GMT

Hi Avinash,

After exporting the straight table data, i am getting the data like below: