CrossTable does not display values

Wed, 26 Sep 2012 14:31:54 GMT

Hey,

hopefully I can describe my Problem appropriately:

I have designed my tables this way: (hope the german identifier are no problem)

The table "Calendar-1" is a CrossTable which looks like this:

Directory;

CrossTable(KOST1, Menge, 2)
LOAD (Datum, 'MM/YYYY'), 'MMYYYY') as CalendarMonthAndYear,

Zeile,

....and so on

For each month (overall 24) I load one of the "Calendar-1" tables. They look pretty much the same. Only the amount of KOST1 are different in each table.

In my first try this exact approach worked well, but I had to format my Input Tables in a different way and import them again.

Only this time the Values in "Calendar-1" are not displayed or loaded correctly. When I display the values of "Calendar-1" in the preview the actual Value "Menge" which I am looking for is not displayed. Instead of the values it contains the values from "KOST1".

My question is: How do I get the table "Calendar-1" to display the actual values for "Menge" instead of "KOST1"?

Sry if explained poorly, but I have a hard time expressing this problem ^^

Thanks a lot, thees

topic CrossTable does not display values in QlikView

CrossTable does not display values