topic Dynamic Guage chart in QlikView

Dynamic Guage chart

Wed, 11 May 2011 16:02:36 GMT

Hi Guys,

I was trying an example from this thread which is written in german by Bernhard

http://community.qlik.com/message/115412#115412

There are two examples attached from Bernhard where in one(lager_problem.qvw),he used the fields in Lowerbound of the Guagesettings and in other(lager-problem_2.qvw) fixed values.

If fixed values are given as Lowerbound it works but if the fields are associated instead of fixed numbers it does not work.

Though on selection of Dimension "artikliefgrp_cd" it works.

I have invested lot of time and could not solve the problem. May be someone can give an Idea.

Regards

Sravan

Dynamic Guage chart

stephencredmond — Wed, 11 May 2011 16:22:58 GMT

Hi Sravan,

This is one that I have run into before. The problem is that you are assuming that the dynamic field value - e.g. LGU_Gelb, will apply for each row of the straight table. You think that it will give you the right bounds on each row.

However, this is not correct! The bounds are not dynamic per row. They are set at the chart (or document) level, not at the row level. Therefore, the only one that will work is LGU_rot because it only has one value - 0. Note that if you select only one article group code (e.g. britax), now the bounds work as you expect.

The right way to get this to work is to have fixed bounds in the guage and then use the dynamic bounds in the expression.

Regards,

Stephen

Dynamic Guage chart

Thu, 12 May 2011 10:02:41 GMT

hi stephen,

Thanks for the answer. It is logical!

Regards

sravan