topic help with creating mini chart in table in QlikView

help with creating mini chart in table

Fri, 26 Nov 2010 13:32:14 GMT

Hi im having a problem configuring my mini chart in a table.

I want the mini chart to appear in the mini chart box (blue) for the indicator in question. The mini chart should have all DATE as dimension and all ACTUAL MTH for data points.

The mini charts should not change if the user makes selections from the user lists.

Basically i want the same mini chart for each indicator Date row.

Can anyone help?

help with creating mini chart in table

Miguel_Angel_Baeyens — Fri, 26 Nov 2010 21:19:34 GMT

Hello,

Find your document attached with some changes, but basically I've created a calendar to base on it instead of using a calculated dimension.

As the sample data was small, I did it using a partial reload, anyway it should return expected values.

Check this file as well.

Hope it helps!

help with creating mini chart in table

Mon, 29 Nov 2010 11:59:47 GMT

Thanks Miguel for your help and your sample file is just what i was looking for.

Just a couple of questions the calendar you used and the script.

Im unfamilar with the REPLACE LOAD / RESIDENT / REPLACE DROP TABLE commands, whats your rationale to using them ?
Why you creating a MIN and MAX date variables?

Regards

Jason

help with creating mini chart in table

Miguel_Angel_Baeyens — Mon, 29 Nov 2010 16:07:09 GMT

Hello Jason,

Since I wanted to add some information but I was unable to reload your document (the excel file was not attached) I added myself some tables to I needed to use performing a partial reload. Among other things, a partial reload allows you to kee your existent loaded data and add new tables, which was the case. So you can forget about the REPLACE keyword. It was the only way to keep your data and load additional piece of script.

The RESIDENT load allows you to load data from an already loaded table.

I wanted to create a master calendar. For that, I need your first fact date and the last one. Then, the calendar is built using these dates as limits. There may be some other ways to do it, but this is the one I know best and that fits my requirements.

Hope this helps.