topic Re: Data Not Displaying in QlikView

Data Not Displaying

Tue, 03 Jul 2012 16:50:33 GMT

Hi there,

I'm fairly new to qlikview. I'm trying to create some pretty simple bar-graphs. I attached the qlikview file and the .dbf file. I followed the exact same procedure in constructing another graph like this and it works fine. I'm sure there's a fairly simple explanation to it but I'm not well enough versed in qlikview to know what that would be.

Re: Data Not Displaying

Anonymous — Wed, 04 Jul 2012 02:00:21 GMT

Hi Akaash,

What is the actual question? The document opens nicely and displays all charts for me

Re: Data Not Displaying

Wed, 04 Jul 2012 14:33:17 GMT

Hi Joahnnes,

I just noticed that I attached the wrong .qvw file, hah... It's fixed know if you'd like to go ahead and try it again. It says that no data is displaying because I think it's trying to plot multiple "amount" values against one "date" value (multiple expressions for one dimension). But if I sum all amount values for a given date value - which is what I want to do anyways - I was thinking that it shouldn't have any trouble plotting. I tried using "sum(amount)" as you can see in chart properties/expressions. This didn't work.

Re: Data Not Displaying

swuehl — Wed, 04 Jul 2012 14:39:58 GMT

It seems to me that your amount values always sum up to zero for any given date (and also any given closing), i.e. negative values balance out positive values.

You see what I mean when using

=sum(fabs(amount))

Re: Data Not Displaying

Wed, 04 Jul 2012 15:07:51 GMT

Yes! You're right Swuehl thank you very much