Cross Table Mis-Behaviour

[#1]

Hi All,

             Is there any possiblity to do the without change the data format and pull into qlikview.(Only this data).

Note: Qlikview basic Cross Table Format method.( I am aware of qlikview Cross table data load).

Regards,

Ravi.

[Anonymous · Accepted solution]

Not very nicely formatted but here goes:

CrossTable(YearMonth, Data)

LOAD F1 as Type,

     [40969.000000],

     [41000.000000],

     [41030.000000],

     [41061.000000]

FROM

Test.xlsx

(ooxml, embedded labels, table is Sheet1, filters(

Remove(Row, RowCnd(CellValue, 2, StrCnd(null))),

Transpose(),

Remove(Row, RowCnd(CellValue, 2, StrCnd(null))),

Transpose()

));

Had to transpose to remove unwanted columns and then transpose back

[deepakk]

hi Ravi,

You can use the basic Cros table load for this. What's the issue in using the cross table ?

Deepak

[#4]

Hi Johannes,

                   Thanks and it works!, That was i am looking for that. Great Job!.

Hi Deepak,

                Please try and you wil come to know on that data.

Regards,

Ravi.

[deepakk]

hi Ravi,

I tried in a normal way and it seems to be working fine. I am using QV 9 SR7

I have attach a sample application and data from the pivot table.

Thanks for your time.

Deepak

[#6]

HI Deepak,

                 We are using QV11 SR1, it doesn't work as it in QV 9 SR7. Because it is a very simple workaround but it doesn't work in QV11. Thanks for your workaround on it. Otherwise try it in QV11 and let me know.

Deepak, i mentioned in my earlier post, we should not to change data format.

Regards,

Ravi.