Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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..