Cross Table Help !!!

[amit_saini]

Hi Folks ,

Please see the attachment and help me why "v" is missing for "C346" , when I do have entries in attached excel

Looks to me so logic issue , while doing cross table.

Thanks,

AS

[Gysbert_Wassenaar]

No, you don't. You only have C346 values for L, not V:

And you have a lot of merged cells in excel. Those will result in lots of empty values in Qlikview because Merged Cells are an Excel trick. The real value exists only in the first (left most) cell of the merged ranged. You'll need to use the transformation wizard to fill the empty cells.

Or perhaps you can use this document: multi_header_pivot_import.qvw

[amit_saini]

Hi Gysbert,

Please check AI , we do have "N" in this case but not "V"

[sunny_talwar · Accepted solution]

I think the issue is that for all other F3 the excel has used Merge & Center to combine the three F2 except for C346. If you do the combine and merge for C346, it would have all the three F2 values available for it as well (attaching the new excel file)

[Gysbert_Wassenaar]

I did check and you do not have V for C346. I have also explained why that is: Merged Cells.