Bar Chart help

Wed, 11 Nov 2015 17:04:28 GMT

Hello,

I’m new to Qlik and wanted to ask a few questions about a bar chart.

I have a SQL data set that has the following Fields:

Annuities, Cash, Equity, FixedIncome, MutualFund, Other, REIT, APA, Direct, ORIA, Brokerage

1. How can I limit my Bar Chart to exclude APA, Direct, ORIA, Brokerage? In SSRS you can use Filters to accomplish this.

2. I have the Bar Chart showing AUM numbers. How you can show the following fields as a percentage of the total (Annuities, Cash, Equity, FixedIncome, MutualFund, Other, REIT). Show each fields as a percentage of the total.

Any information would be greatly appreciated.

Thanks,

Re: Bar Chart help

settu_periasamy — Fri, 13 Nov 2015 03:14:24 GMT

Hi,

After Loading your data, Create a Bar Chart, Dimension as AUM Numbers,

expression like

=Num(

Sum(Annuities)/Rangesum(sum(Annuities), sum(Cash), Sum(Equity), Sum(FixedIncome), sum(MutualFund),sum(Other),sum(REIT)),

'#,##0.00%')

Like wise, you can create the Other expressions for Cash, Equity etc..

topic Bar Chart help in QlikView

Bar Chart help

Re: Bar Chart help