topic QV won't display data in QlikView

QV won't display data

Sun, 02 May 2010 20:10:33 GMT

Hello!

I just loaded an excel file into qv, and saved it. Problem is that i can't create any graphs, i only get the message "No data to display".

This would probably be because of me screwing up the loading procedure, but the thing is that my friend sitting next to me can do all the graphs he wants using my qvw file, that I just shared with him.

Any thoughts on what might be the problem?

Thankful for any help!

QV won't display data

fernandotoledo — Sun, 02 May 2010 22:02:42 GMT

This could be the interpretation of the fields, like numbers loaded as text.

See the num#() or date#() functions to load data correctly.

You might be making any mistake in the chart creation.

QV won't display data

Oleg_Troyansky — Mon, 03 May 2010 00:41:59 GMT

sounds like a mistake, most likely in your Chart Expression. Make sure you use some kind of aggregation in the expressions:

For example, use "sum(Amount)" instead of just "Amount"

QV won't display data

Mon, 03 May 2010 08:09:36 GMT

Thanks for your help.

No, the problem is not in the chart, I can guarantee that. Tried it on his computer aswell, and I've tried 6 different aggregations