topic Reference line in Chart in QlikView

Reference line in Chart

Wed, 11 Nov 2009 19:51:12 GMT

I want to have a reference line in a chart depending on variabel data. In this case I want to select 2 items in a list box. When this is the case a reference line has to appaer based on a calculation from 2 variables.

When selecting 1 item from the list box it is no problem and the correct reference line is displayed. When selection 2 items I could not find the correct conditional formula to display the correct reference line.

Example 1 seletion:
Expression: ManCapMO001*Normal
Conditional: Department='MO001'

Example 2 selections:
Expression: (ManCapMO001+ManCapMO002)*Normal
Condional: ????

Is there a solution to display the correct reference line?

Reference line in Chart

prieper — Thu, 12 Nov 2009 04:33:26 GMT

Not quite clear to me, what you wish to achieve. You can enter different conditions and as consequence display different values, and you may also show/hide the reference-lines subject to certain conditions.

Peter

Reference line in Chart

Thu, 12 Nov 2009 21:42:56 GMT

I know. Just try to use the conditions with more then one selection to display a reference line.

More concrete example: I select 2 departments (dep1 and dep2) in a listbox to see the remaining hours.

I want to have a reference line for the capacity defined by variances 'hours a week' multiply available mancapacity.

I can not find a formula (?) to display under conditions showing the reference line only when those departments (dep1 and dep2) are selected.

Reference line in Chart

prieper — Thu, 12 Nov 2009 22:33:01 GMT

Have you had a look into the GETCURRENTSELECTIONS() or GETFIELDSELECTIONS() etc? You may then inspect it with WILDMATCH() in order to formulate your conditions, e.g.

WILDMATCH(GETFIELDSELECTIONS(Departments), '*Dept1*', '*Dept2*')

HTH
Peter