topic Re: Cross Table Mis-Behaviour in QlikView

Cross Table Mis-Behaviour

Thu, 05 Jul 2012 06:12:34 GMT

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.

Re: Cross Table Mis-Behaviour

Anonymous — Thu, 05 Jul 2012 06:20:18 GMT

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

Re: Cross Table Mis-Behaviour

deepakk — Thu, 05 Jul 2012 06:21:05 GMT

hi Ravi,

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

Deepak

Re: Cross Table Mis-Behaviour

Thu, 05 Jul 2012 06:29:07 GMT

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.

Re: Cross Table Mis-Behaviour

deepakk — Thu, 05 Jul 2012 07:09:31 GMT

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

Re: Cross Table Mis-Behaviour

Thu, 05 Jul 2012 07:17:43 GMT

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.