Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

CrossTable does not display values

Hey,

hopefully I can describe my Problem appropriately:

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

tables.JPG

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

0 Replies