Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

rutger_jansen
New Contributor II

Adding static expression overrides second dimension

Hi All,

I'm trying to display a 'static' expression in a chart whilst preserving a second dimension.

The .qvw attached demonstrates this better than I can explain it. Switch the options listbox to 'yes' to see the effect I'm trying to avoid;  aggregation of the actuals.

Put differently, I want to display the 'plan' line if the options = 'yes' AND I still want all the other lines -those visible when options is set to 'no'- to be displayed.  When options = 'yes' there should be 4 actuals and one plan line, otherwise just 4 actuals.

Background: I need to display plan data (which will actually be a set of linear equations) in the same chart as the actuals and I want to cycle through possible second dimensions using a cyclic group (though the the example only shows a single second dimension)

Any help would be greatly appreciated.

Regards

Rutger

Tags (2)
1 Solution

Accepted Solutions

Re: Adding static expression overrides second dimension

You're right, it is a Qlikview limitation. If the options I outlined do not fulfill your requirements then you will have to use two charts and put them on top of each other. 


talk is cheap, supply exceeds demand
4 Replies

Re: Adding static expression overrides second dimension

A line chart can have either two dimensions and one expression or one dimension and N expressions. So you can create four expressions, one for each quarter, and an expression for your Plan value with only the PIT dimension. Or you can add a reference line on the Presentation tab. Since your plan value of .3 is static anyway over the PIT values that is the easiest solution. See attached example.


talk is cheap, supply exceeds demand
rutger_jansen
New Contributor II

Re: Adding static expression overrides second dimension

Hi Gysbert,

Your first suggestion would work but means I'd have to create a separate expression for every possible interval; the real data will have months, quarters, years and combinations of these which should be selected by the user.


Regarding the second suggestion, I can't use the reference line because I want the user to choose from several (linear rather than constant) plan/target lines to include in a graph.


For example, the user might select a subset of the data (based on dimensions not shown in the sample file), specify 3 different quarters (e,g, 2013-Q3 to 2014-Q1) to display for that subset and then add a plan line that is most appropriate for the given selection.


Thanks very much for your help,


Rutger


PS: This* is a QlikView limitation as opposed to a logical limitation, right?

* A line chart can have either two dimensions and one expression or one dimension and N expressions.

Re: Adding static expression overrides second dimension

You're right, it is a Qlikview limitation. If the options I outlined do not fulfill your requirements then you will have to use two charts and put them on top of each other. 


talk is cheap, supply exceeds demand
rutger_jansen
New Contributor II

Re: Adding static expression overrides second dimension

Great, thanks again.

Community Browser