topic Data not appearing in my Chart/Table object in QlikView

Data not appearing in my Chart/Table object

Wed, 24 Oct 2012 00:41:00 GMT

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

Re: Data not appearing in my Chart/Table object

Wed, 24 Oct 2012 01:05:13 GMT

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

Re: Data not appearing in my Chart/Table object

Wed, 24 Oct 2012 04:20:29 GMT

can u post ur script ?

Re: Data not appearing in my Chart/Table object

Wed, 24 Oct 2012 04:24:31 GMT

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

Re: Data not appearing in my Chart/Table object

Wed, 24 Oct 2012 04:33:56 GMT

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

Re: Data not appearing in my Chart/Table object

Gysbert_Wassenaar — Wed, 24 Oct 2012 17:26:30 GMT

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.