topic Re: Help in grouped bar chart in QlikView

Help in grouped bar chart

aniketsr — Thu, 17 May 2018 14:39:28 GMT

Hi ,

I have a requirement as per the attached format, in this format we have two dimensions country and business.

and along with that we have two expressions one is a negative value and other is positive value

I have used bar chart with two dimensions and when i use only one expression we get the color of the bar according to the country, but later when i put the second expression we get the bar color as per the expressions..

i need guidance on how can i use two expressions and two dimensions and the color of the bar should be based on the one dimenision which is country dimension.

attached is the image for reference.

Thanks in advance..

Re: Help in grouped bar chart

vishsaggi — Thu, 17 May 2018 15:09:49 GMT

Can you share a sample to look into?

Re: Help in grouped bar chart

Gysbert_Wassenaar — Thu, 17 May 2018 16:16:18 GMT

A bar chart can have two dimensions and one expression or it can have one dimension and lots of expressions. The combination of two dimensions and two expressions is not possible. But perhaps you can turn your two expressions into one expression that returns a positive or negative values as necessary.

Re: Help in grouped bar chart

aniketsr — Fri, 18 May 2018 07:38:31 GMT

Hi Gysbert,

Thank you for the information

Need some guidance on how and what will be the best way to implement a chart as per the attached image.

Re: Help in grouped bar chart

vishsaggi — Fri, 18 May 2018 14:07:41 GMT

You may want to use cyclic dimensions and two expressions and you can switch dimensions accordingly. Can you share a sample or output based on what Gysbert advised?

Re: Help in grouped bar chart

aniketsr — Tue, 22 May 2018 23:10:44 GMT

Hi ,

I have two simple expressions

Expr1= sum({ <status={`buy`}> }sales)

Expr2= sum({ <status={`sell`}> }sales)*-1

Can you please guide how can I convert these expressions in one.

Thanks

Re: Help in grouped bar chart

vishsaggi — Tue, 22 May 2018 23:43:01 GMT

May be this?

= Sum({<status = {'buy', 'sell'} >}sales) *-1

Re: Help in grouped bar chart

aniketsr — Wed, 23 May 2018 06:04:54 GMT

In this expression we are multiplying both the sell and buy with (-1)

Re: Help in grouped bar chart

aniketsr — Wed, 23 May 2018 07:59:43 GMT

for sell it should be multiplied by 1 and for buy the expression should be multiplied by -1

Re: Help in grouped bar chart

aniketsr — Wed, 23 May 2018 08:15:38 GMT

Hi Gysbert,

I have two simple expressions

Expr1= sum({ <status={`buy`}> }sales)

Expr2= sum({ <status={`sell`}> }sales)*-1

Can you please guide how can I merge these expressions in one.

for sell it should be multiplied by -1 and for buy the expression should be multiplied by 1

Thanks

Re: Help in grouped bar chart

Gysbert_Wassenaar — Wed, 23 May 2018 14:41:49 GMT

perhaps: rangesum(sum({ <status={`buy`}> }sales), sum({ <status={`sell`}> }sales)*-1)

Re: Help in grouped bar chart

aniketsr — Thu, 21 Jun 2018 09:01:33 GMT

Hi Gysbert,

I used the expression above it is working fine iam getting the Desired view ,

But when i deep dive into selection due to rangesum suppose Buy is 1 MM and Sell is -6 MM the in the out put we get -5 can i get some guidance on the same.

Re: Help in grouped bar chart

Gysbert_Wassenaar — Thu, 21 Jun 2018 09:13:27 GMT

1 - 6 = -5 afaik. So, what's the problem?

Re: Help in grouped bar chart

aniketsr — Thu, 21 Jun 2018 10:54:39 GMT

According to the requirement we wanted to have one expression for buy and sell wherein , the BUY bar should be in the positive end of the bar chart and SELL should be on the negative side.

Now suppose for a specific date , buy was 1 and sell was -6 then for that particular date there shall be two bars one at the positive side and the other on the negative side , but now because of rangesum it is summing the two values and as the output is in negative then the bar is showing at the negative end.

please guide me if we can keep the values static for a specific date