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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Data Not Displaying

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.

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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))

View solution in original post

4 Replies
Anonymous
Not applicable
Author

Hi Akaash,

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

Not applicable
Author

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. 

swuehl
MVP
MVP

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))

Not applicable
Author

Yes! You're right Swuehl thank you very much