topic How to add value at run time? in QlikView

How to add value at run time?

Fri, 21 Nov 2014 08:06:21 GMT

HI All,

I have brand list and its some value like

Brand Value

A 10

B 20

C 30

So, what I am doing is.

I have created bar chart. in that want to show below and above avg.

So for that I want to create 1 extra bar with avg.

So, I can identify below and above.

By add in database I can achieve

But it will show in filter as well so I don't want that thing.

Thanks

Re: How to add value at run time?

Peter_Cammaert — Fri, 21 Nov 2014 09:00:26 GMT

Why not use a Reference line? (see Properties->Presentation->Reference Lines) They're made for this and add a clear indicator without rearranging your object or taking away the focus from the actual values. Also, a reference line will behave better when a lot of brand values are displayed, while an additional bar may disappear altogether...

Add an expression like =avg(Value), and a suitable line text. The label can include the numerical value if you create a label expression like:

='Avg = ' & num(avg(Value), '#0')

Re: How to add value at run time?

alexandros17 — Fri, 21 Nov 2014 09:03:18 GMT

In the actions or triggers of objects (buttons for example) you can generate extra sql code to add more information, go to External -> Dynamic Update

Take a look at the help online ... and let me know

Re: How to add value at run time?

Fri, 21 Nov 2014 09:07:53 GMT

Peter I want like this.

which is not possible with that reference line.

So, I am going for 1 extra bar.

Re: How to add value at run time?

Peter_Cammaert — Fri, 21 Nov 2014 09:15:03 GMT

I'm with you.

Have a look at this great post (as always) by HIC: http://community.qlik.com/blogs/qlikviewdesignblog/2013/12/09/pareto-analysis

He explains how to divide bars into categories and how to let them stand-out based on specific conditions. The same technique can be applied to your situation, I think.

Re: How to add value at run time?

Fri, 21 Nov 2014 09:20:07 GMT

Sorry for that statement.

I have gone through that link. But peter my requirement is like vertical line. So, ..

Thanks.

Re: How to add value at run time?

Sat, 22 Nov 2014 07:46:03 GMT

Can you give any example how to use that dynamic update in qlikview?