topic Re: Custom expression In Bar Chart in QlikView

Custom expression In Bar Chart

help4qv123 — Thu, 08 Feb 2018 06:10:18 GMT

Hello Experts,

I need some help on custom expressions.

As we know we can apply the custom expression to that bar chart.

Here the scenario is suppose i have a bar chart which compares the value( Actual vs Previous).

Bar chart with two bars..I want to have two custom expressions.

When i give the expressions it only considers one custom expression.

What if i want two ?

I have attached a sample test file. Please have a look..

Thanks in advance.

Re: Custom expression In Bar Chart

prma7799 — Thu, 08 Feb 2018 06:13:31 GMT

Like this you want ??

Re: Custom expression In Bar Chart

help4qv123 — Thu, 08 Feb 2018 06:25:26 GMT

As per my attachment you can see there are only two bars. with some expression.

On the value display i want some other expression(custom) to be displayed.

For example if you are showing the sum of some value. i want to show it percentage with its sum to be displayed.

But the bar expression is calculated on the basis of its sum.

Hope you got my point.

Re: Custom expression In Bar Chart

avinashelite — Thu, 08 Feb 2018 06:37:28 GMT

what's the custom expression your taking about ...I could see your using 2 expression and enable bar for it ...for the other 2 you have not enabled any bar or text pop-up and what your expecting it to show ...I confused

Re: Custom expression In Bar Chart

tresB — Thu, 08 Feb 2018 06:52:17 GMT

May be using Dual() like:

You can replace 555 with your custom expression.

Re: Custom expression In Bar Chart

help4qv123 — Thu, 08 Feb 2018 06:57:18 GMT

But if i use dual. according the value the bar also changes.

I want to show my bar with sum(Value). And value on popup(In place of 555 i want to show sum and its percentage).

Re: Custom expression In Bar Chart

tresB — Thu, 08 Feb 2018 07:00:37 GMT

No it doesn't. The bar would always be based on your second argument passed - (Sum(F4) in my sample). You see all bars are showing 555, but the bar lengths are different, isn't it?

Re: Custom expression In Bar Chart

help4qv123 — Thu, 08 Feb 2018 07:08:32 GMT

To Be more clear . See the screenshot below.

There is one bar chart with some data . The second chart expression is different (%).

I want to display them on the 1st chart.

Re: Custom expression In Bar Chart

tresB — Thu, 08 Feb 2018 07:17:47 GMT

Not sure if understood right. This?

Re: Custom expression In Bar Chart

help4qv123 — Thu, 08 Feb 2018 11:36:42 GMT

Yes. This Works. Thanks for the Time:)