1 Reply Latest reply: Nov 12, 2015 10:14 PM by Settu Periyasamy RSS

    Bar Chart help

      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 Periyasamy

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