Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Data not appearing in my Chart/Table object

Hi everyone

I am very new to Qlikviwe, but have created an extract, which loads data into a table (see schema image attached). I can browse the data via the schema view, but when I create a Table Chart object, nothing appears, even when I have sothing selected in my filters.

The Master Calendar object is a ring-in from another project (that someone else wrote), and something I will need eventually, I presume.

Would the lack of a link between the schema objects stop data appearing in my chart/table object? I have eliminates nulls from the data, and can't wrk out why nothing will display.

Thanks, ope someone can give a newbie some pointers.

Don

1 Solution

Accepted Solutions
Not applicable

Re: Data not appearing in my Chart/Table object

Check the dimension limits from property, if everything is fine, then check other property settings,plus, dont forget to SELECT something

5 Replies
Not applicable

Re: Data not appearing in my Chart/Table object

Sorry about the spelling in the above post.

I have removed the Master Calendar table in the scema (first attached image) in case the lack of a link was an issue. There is only one table now in my schema, which I can Preview in the schema view, and confirm that it contains data.

Still nothing appears in my Chart/Table object, either when filters are selected, or no filters selected.

Any ideas of where to start looking would be greatly appreciated. I don't really want to pull my SQL extract back to 1 or 2 coulmns, but if this is the only way I can get data to view, and slowly add columns to the extract, then I guess that's what I'll have to do. Anywhere else obvious to look first?

Thanks

Not applicable

Re: Data not appearing in my Chart/Table object

can u post ur script ?

Not applicable

Re: Data not appearing in my Chart/Table object

Check the dimension limits from property, if everything is fine, then check other property settings,plus, dont forget to SELECT something

Not applicable

Re: Data not appearing in my Chart/Table object

there is something wrong with my internet just now, sorry about the repeat post

Re: Data not appearing in my Chart/Table object

I'm guessing you've created a chart (pivot or straight table) and haven't added an expression, but only dimensions. If that's so then there won't be anything to display. You'll need to add an expression too.

In a table box you can only add fields and no expressions. Table boxes are nice for simply displaying a table of some fields. So if you only want a table showing a couple of fields you can use a table box.


talk is cheap, supply exceeds demand
Community Browser