Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Simple bar chart of 2 variables

Hey,

I'm totally knew to Qlikview and I want to make a barchart of ProductID and UnitsInStock.

I have a table, called products that has a column ProductID and a column UnitsInStock, so I just want those 2 on a bar chart.

But how do I do this? Cause if I choose ProductID as first dimension and as expression UnitsInStock, it doesn't work.

Do I always have to use count, sum or something else in the expression?

Thanks in advance!

13 Replies
Not applicable
Author

The problem is indeed that ProductID is used in other tables in our database.

I tried an application with only the table products and than it works with dimension=productID and expression: UnitsInStock

Isn't it possible to only use the ProductID of the table products, like products.productID in sql.

richard_chilvers
Specialist
Specialist

Yes, it is possible.

But it may be that you need to check the structure of your data is in good order, which may well sort out the problem.

If you use Ctrl T to show your data, make sure there are no unsual relationships going on.

Not applicable
Author

So products.productID should work?

I don't think there are unusual relationships

richard_chilvers
Specialist
Specialist

Did you try Ctrl T ?

You can QUALIFY the field productID in the script which means it is no longer linked to other tables. (Take a look at the online help).

You should then be able to do what you suggest. When you list the fields in your chart object, you will see products.productID is now listed. But it is not a good solution and could easily affect other objects in your application.