topic how to display Bar Chart based on expression values in QlikView

how to display Bar Chart based on expression values

Tue, 03 Jun 2014 14:31:36 GMT

Dear all,

In my grouped bar chart 2 exps are there,and my requirement is to display in one chart when exp1 > exp2 values only .and in other chart when exp 1< exp2 values only.

Could you advise as to how I could achieve the above?

Thanks,

Shekar

Re: how to display Bar Chart based on expression values

Tue, 03 Jun 2014 14:51:18 GMT

Hi Shekar,

Why don't you use the same chart with

if(expr1 > expr 2, expr1, expr2)

chris

Re: how to display Bar Chart based on expression values

Tue, 03 Jun 2014 14:57:46 GMT

Hi ,

if(expr1 > expr 2, expr1, expr2) then only one exp value will get display .

But i need to display both values in the chart.

Like in one chart Gross vs Net values for a dimenison where Net > Gross and in other chart Gross Vs Net for a dimension when Gross > Net.

Re: how to display Bar Chart based on expression values

vardhancse — Tue, 03 Jun 2014 15:04:03 GMT

hi can you try to multiple if conditions like

if 1 condition was satisfied, then exp 1,

if 2nd condition was satisfied, then exp 2

Re: how to display Bar Chart based on expression values

Tue, 03 Jun 2014 15:06:33 GMT

Shekar

then make 2 grpahs with

if(expr1 > expr 2, expr1) for one

if(expr2 > expr 1, expr2) for the other

chris

Re: how to display Bar Chart based on expression values

vardhancse — Tue, 03 Jun 2014 15:16:12 GMT

Hi,

For grouped chart it should have min 2 expressions.

Re: how to display Bar Chart based on expression values

Tue, 03 Jun 2014 15:25:09 GMT

Hi,

But i have to display both exp in both the charts like when exp1>exp2 then exp1 & exp2 both values in one chart and when exp1<exp2 then exp1& exp2 both values in other chart.

Thanks,

Re: how to display Bar Chart based on expression values

Tue, 03 Jun 2014 15:36:22 GMT

OK so

in Graph 1

expr 1 : if (expr 1 > expr 2, expr 1)

expr 2 : if (expr 1 > expr 2, expr 2)

in Graph 2

expr 1 : if (expr 2 > expr 1, expr 1)

expr 2 : if (expr 2 > expr 1, expr 2)

chris

Re: how to display Bar Chart based on expression values

Tue, 03 Jun 2014 15:41:42 GMT

Have you considered using the "Show - Conditional" option on the Layout tab for the charts?

On one chart, you can enter =if(exp1>exp2,1,0) and on the second you can enter =if(exp1<exp2,1,0) as your conditional show expressions...

Would this work for your purpose?

Re: how to display Bar Chart based on expression values

Thu, 05 Jun 2014 00:54:17 GMT

Hi Christianj,

Thanks for your quick reply,its working as expected.

Thanks,

Shekar

Re: how to display Bar Chart based on expression values

Thu, 05 Jun 2014 12:18:13 GMT

Hi Shekar,

my pleasure.

just click it as correct

best regards

Chris