topic Re: Need help in bar chart in QlikView

Need help in bar chart

Mon, 09 Jun 2014 06:31:00 GMT

Hi QV,

In the attached sample, I need to show Total as constant even after any value selection in the list box.

Is it possible to show totals irrespective of any value selection.

Suppose

If I select Accenture in the list box, then in the chart I want to display one bar with accenture data and the other bar will display totals of all.

Thanks in advance..

Ananth

Re: Need help in bar chart

tresB — Mon, 09 Jun 2014 06:38:07 GMT

Like attached?

Re: Need help in bar chart

Mon, 09 Jun 2014 06:40:36 GMT

I'm sorry, I'm using personal edition, please can you post the steps please

Re: Need help in bar chart

tresB — Mon, 09 Jun 2014 06:42:40 GMT

Remove, 'Managed Accounts' from dimension and try expression as:

=sum({<[Managed Accounts]>} [Final Rm Rev Result])/sum({<[Managed Accounts]>} [Final Account Rm Rev Goal])

Re: Need help in bar chart

Mon, 09 Jun 2014 06:49:10 GMT

Many Thanks tresesco.

It was very helpful for me.

One thing I just want to clarify, The above expr is fine if there is only one expression present in the chart, if I have multiple expressions present in the chart then, what could be the solution

Thanks,

Ananth

Re: Need help in bar chart

tresB — Mon, 09 Jun 2014 06:54:51 GMT

This solution is expression dependent. The '{<[Managed Accounts]>}' segment of the expression causes to sum all the values irrespective of selection in the field 'Managed Accounts'. Therefore, if you want the similar behaviour for other expressions/metrics as well, you just have to include this set analysis part there too. For ex.: if you have another expression like: Sum(Amount), you have to re-write it as : Sum({<[Managed Accounts]>}Amount). Hope this helps.

Re: Need help in bar chart

Mon, 09 Jun 2014 06:58:42 GMT

When I try the above expression, I'm getting only Accenture data and Accenture total.

Actually my requirement is to get the all total bar even after any selection in the list box,

means 1 bar should display selected value data and other bar should display the totals of all.

Re: Need help in bar chart

tresB — Mon, 09 Jun 2014 07:04:08 GMT

Possibly, you are doing mistake somewhere writing the expression. Paste the exact expression you are trying with, I will try to figure that out for you.

Re: Need help in bar chart

Mon, 09 Jun 2014 07:11:36 GMT

I did exactly what you have given above.

When I try that, I got below chart.

No selection in the list box.

But what i'm expecting is if I select accenture in the list box, then first bar should display accenture data and second bar should display the grand total.

but in the above chart both bars are displaying accenture data only.

The grand total should remain constant even after any selection.

Re: Need help in bar chart

tresB — Mon, 09 Jun 2014 07:20:14 GMT

Dimension: [Property Name]

Expression For Total: =sum({<[Managed Accounts]>} [Final Rm Rev Result])/sum({<[Managed Accounts]>} [Final Account Rm Rev Goal])

Expression for usaul selection:

=sum([Final Rm Rev Result])/sum( [Final Account Rm Rev Goal])

Re: Need help in bar chart

Mon, 09 Jun 2014 07:25:18 GMT

Now my chart is not responding to any selections in the list box.

But it should reflect based on selection and grand total remains unchanged

Re: Need help in bar chart

tresB — Mon, 09 Jun 2014 07:27:16 GMT

Have you taken two expressions?

Re: Need help in bar chart

Mon, 09 Jun 2014 07:29:51 GMT

No, only one expression is there as I posted in the sample.

Re: Need help in bar chart

ashfaq_haseeb — Mon, 09 Jun 2014 07:43:45 GMT

go to chart properties--> dimension limit--> deselect show total.

Now add one more expression shown below.

=sum([Final Rm Rev Result])/sum( [Final Account Rm Rev Goal])

Regards

ASHFAQ

Re: Need help in bar chart

tresB — Mon, 09 Jun 2014 08:01:27 GMT

Take two expressions (different) as I mentioned in earlier post when dimension would be [Property Name]

Re: Need help in bar chart

Mon, 09 Jun 2014 08:56:28 GMT

Thank you very much tresesco, Now it's working as I expected

Re: Need help in bar chart

Mon, 09 Jun 2014 09:01:10 GMT

Is it possible to display all the bars if there is no selection.

Now its giving grand total bar and selected value bar.

if there is no selection in the sheet, I would like to get grand total bar along with all the values bars.

Thanks,

Ananth