CrossTable is not enough, as far as I know. Do you know?

[nenadvukovic]

Hi,

If you have a table structured like this:

                         P1      P1      P2      P2

Customer      Volume Price Volume Price

ABC                100      10      200      11

DEF                300      20      400      21

using the CrossTable function, I can't get this:

Customer      Period     Volume Price

ABC                P1          100      10

ABC                P1          200      11

DEF                P2          300      20

DEF                P2          400      21

Thanks a lot

I get two unexpected rows and incorrect Price:

Message was edited by: Nenad Vuković

[nenadvukovic]

[sunny_talwar]

Is it possible to replace all the nulls with 0s in your Excel file for Volume and Price? That should fix the problem

[nenadvukovic]

If that is the only way I'll modify null value cells to contain 0. Thank you

[sunny_talwar]

Mastermind behind this qvw might have a better idea. gwassenaar‌ can you offer your expert advice?

[nenadvukovic]

Hi, is it possible that none of the cells can be left empty? I have problems with some text fields (notes) that are rightfully empty and are not read into the FinalTable.

Is it really possible that QlikView can't handle this type of Excel files?

[sunny_talwar]

gwassenaar‌ do you have any suggestion?

[nenadvukovic]

Why is the DISTINCT keyword used? Does this eliminates duplicates? If yes, then this is not good.

load distinct SalesmanNameID, SellingLocation, CO_ID, Currency, CustomerNameID, [Demand Family], TypeL, Year, DP_Assumption, FPeriod

resident ResultTable;

[nenadvukovic]

In those load statements, I've replaced empty values with a special character to avoid having it empty. For now, it works, but I need to monitor this closely as this has been put into production.

I would appreciate any concrete solution to this issue. Thanks to all interested in this.