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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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

Labels (1)
0 Replies