Issue with Cross Table

[ArchanaSR]

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

[Anil_Babu_Samineni]

There is nothing wrong for me, If we look

Row Date table as raw data?

What i am getting as Expected result?

[ArchanaSR]

Spoiler

Hi,

Thanks for the reply.

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

Regards,

Archana

[Brett_Bleess]

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