topic Partial Load and Trellis Chart in QlikView

Partial Load and Trellis Chart

Tue, 21 Jul 2009 15:33:08 GMT

I have below questions:

How to do partial load of data in QlikView9.0. I have already loaded data for some tables from CSV files and now need to add data for another CSV file.Once i do 'Reload', it loads data for all other loaded CSVs too. So need to know how to load a specific CSV in Script.
I have created a Trellis chart on 'Quarter' variable and a dim & some expressions. Chart values are lower for some quarters and larger for other quartes so scale of Charts are not visibale for lower values as compared to larger values. I tried to change the scale in Axes->(min.max,step) value. Is there a way to define separate scale for each quarter in Trellis chart.

Thanks all.

Partial Load and Trellis Chart

Tue, 21 Jul 2009 15:56:55 GMT


sunil18vns wrote:
 <ul><li>I have created a Trellis chart on 'Quarter' variable and a dim & some expressions. Chart values are lower for some quarters and larger for other quartes so scale of Charts are not visibale for lower values as compared to larger values. I tried to change the scale in Axes->(min.max,step) value. Is there a way to define separate scale for each quarter in Trellis chart. </li></ul>
Thanks all. <div></div>

It is currently not possible to have different scales in each trellis segment. Usually, the trellis chart is useful for comparing values between the segments and that is the reason to why the scales are the same in all segments. But if you would like to compare trends, instead of quantitative data, it might be useful to have different scales in each segment. But unfortunately, QV does not yet support this feature.

Partial Load and Trellis Chart

Tue, 21 Jul 2009 15:57:31 GMT

For the partial reload, just add the "add" before the LOAD in the script and then choose partial reload instead of reload.