Bar Chart help

[#1]

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,

[settu_periasamy]

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..