topic Issue with Cross Table in QlikView

Issue with Cross Table

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

Hello,

I am new to QlikView and working on cross tables. I am getting the below issue.

In my cross table some extra rows are getting added, something similar to the screenshot attached.

The extra rows are getting added from other product ID which is not selected.

Thanks for your help, I appreciate it.

Regards,

Archana

Re: Issue with Cross Table

Anil_Babu_Samineni — Tue, 26 Nov 2019 11:53:19 GMT

There is nothing wrong for me, If we look

Row Date table as raw data?

What i am getting as Expected result?

Re: Issue with Cross Table

ArchanaSR — Fri, 29 Nov 2019 09:09:00 GMT

Hi,

Thanks for the reply.

Row Data table as raw data but cleaned up table as expected result.

Regards,

Archana

Re: Issue with Cross Table

Brett_Bleess — Mon, 09 Dec 2019 21:42:05 GMT

I almost missed things here as you made the names awfully similar, not a good idea for future reference, as I am betting Anil may have missed it too. The product foo seems to be the issue, those two records associated with it are somehow becoming product too, but I have no idea how, would venture you have something in your load script that is reassigning those rows somehow. You may need to attach the QVW you have, if you have one, so folks can see the script, data model and chart to try to sort out what is going wrong where.

Regards,
Brett