Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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))
Hi Akaash,
What is the actual question? The document opens nicely and displays all charts for me
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.
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))
Yes! You're right Swuehl thank you very much