topic How to make a selection box based on expressions in a chart in QlikView

How to make a selection box based on expressions in a chart

Mon, 09 Jan 2012 11:00:09 GMT

Hello,

I have made a chart with several expressions (X-Axis = Time and Y-Axis=Value). Line A has Values ranging from 10 to 100 and Line B has values ranging from -1000 to +1000 whichc causes that Line A becomes just a straight...

To solve this, I would like to make a selection box of all the different lines. How can I do this? The expressions are based on different tables so there is not a real easy link between them...

Any idea how I should make this selection box?

How to make a selection box based on expressions in a chart

Mon, 09 Jan 2012 14:54:10 GMT

Hello,

my suggestion in QV 10 is to create variables to show / don't show an expression.

- The vars can be set by the user via a common inputbox.

- in your expressions you can use the vars in different ways like

- - if(vShowExpr2='yes', sum(Val))

- -avg(Val2)*vShowExpr1 // with suppress Zero-Val checked . . .

AND:

QV11 has got a new feature making this more comfortable. In the new version you are able to create a condition to show an expression or not. See properties-> Expressions -> Conditional. With the creating of several variables and a common inputbox it is more comfortable and a better "fitting" for both, designer and user.

HtH

Roland

How to make a selection box based on expressions in a chart

Wed, 11 Jan 2012 13:12:39 GMT

Thanks for the help. I am using v11 so I was able to use the conditional formatting.

Now I encountered another problem with this solution:

- I have about 10 expressions with each a different conditional statement. All are linked to list box (with parameter Line). When you select 'Line 1" in the box the char shows Line 1 because the conditional expression is: Line='Line 1'.

Sounds good but when the user wants to select 2 lines at once, it doesn't work anymore and the chart does not show a single line. What should I change to this conditional statement?

Regards,

Steven

Re: How to make a selection box based on expressions in a chart

Wed, 11 Jan 2012 17:50:34 GMT

Does anyone have an idea?

Re: How to make a selection box based on expressions in a chart

Thu, 12 Jan 2012 09:29:53 GMT

Hi Steven,

can't catch your problem. Are you able to send a little example app?

Re: How to make a selection box based on expressions in a chart

Thu, 12 Jan 2012 11:22:13 GMT

Hey,

Thank you for responding Robert. My QVW-file is filled with confidential data so I cannot share this but I tried to recreate the situation in Excel (attachment).

Keep in mind that the amounts listed there, are sums of purchases made in that month (of cloths, socks, etc)

Thanks for your help!

Steven

How to make a selection box based on expressions in a chart

Thu, 12 Jan 2012 11:36:49 GMT

try to use combo chart....might be your prob. gets solved.

How to make a selection box based on expressions in a chart

Thu, 12 Jan 2012 11:47:16 GMT

I tried it but it doenst work. I do not know why you think that woul work...

The different lines can be shown all at once but then some lines would not stand out because of their low absolute values.

thats why I created the selection box and added the conditional expression for each line, but I want to be able to select more than one line though... how can this be done?

Another question: The X-axis is showing the months in the wrong order (from december to january instead of the other way around: I changed the sort to Numeric Value Ascending but it didnt work...

Re: How to make a selection box based on expressions in a chart

Tue, 17 Jan 2012 09:08:08 GMT

Hi Steven,

was some days very busy.

But I hope this answer is not too late and points into right direction. Check out the app I build with your (slightly modified) example data.

Re: How to make a selection box based on expressions in a chart

Tue, 17 Jan 2012 09:27:01 GMT

Hey Roland,

Thanks a lot for your reply and your solution. I tried a lot of things myself and kind of settled with I was able to do but this suggestion made it work exactly how I had it in mind!

Very much appriciated!

Steven