topic Re: Cross Table Help !!! in QlikView

Cross Table Help !!!

amit_saini — Wed, 09 Mar 2016 07:43:35 GMT

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,

Re: Cross Table Help !!!

Gysbert_Wassenaar — Wed, 09 Mar 2016 07:51:11 GMT

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

Re: Cross Table Help !!!

amit_saini — Wed, 09 Mar 2016 07:57:48 GMT

Hi Gysbert,

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

Re: Cross Table Help !!!

sunny_talwar — Wed, 09 Mar 2016 09:03:18 GMT

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)

Re: Cross Table Help !!!

Gysbert_Wassenaar — Wed, 09 Mar 2016 09:08:11 GMT

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