Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have been try to achieve the summary of a particular selection as shown in the excel sheet on qlikview.
I have tried aggr, set analysis and have not reached anywhere.
Appreciate if someone could help on this.
Year | Portfolio | SumProduct | Value | Summary - Year - Portfolio | Ratio |
2009 | A | 2009A | 100 | 1500 | 6.67% |
2009 | A | 2009A | 200 | 1500 | 13.33% |
2009 | A | 2009A | 300 | 1500 | 20.00% |
2009 | A | 2009A | 400 | 1500 | 26.67% |
2009 | A | 2009A | 500 | 1500 | 33.33% |
2009 | B | 2009B | 600 | 4000 | 15.00% |
2009 | B | 2009B | 700 | 4000 | 17.50% |
2009 | B | 2009B | 800 | 4000 | 20.00% |
2009 | B | 2009B | 900 | 4000 | 22.50% |
2009 | B | 2009B | 1000 | 4000 | 25.00% |
2010 | C | 2010C | 1100 | 6500 | 16.92% |
2010 | C | 2010C | 1200 | 6500 | 18.46% |
2010 | C | 2010C | 1300 | 6500 | 20.00% |
2010 | C | 2010C | 1400 | 6500 | 21.54% |
2010 | C | 2010C | 1500 | 6500 | 23.08% |
2010 | D | 2010D | 1600 | 9000 | 17.78% |
2010 | D | 2010D | 1700 | 9000 | 18.89% |
2010 | D | 2010D | 1800 | 9000 | 20.00% |
2010 | D | 2010D | 1900 | 9000 | 21.11% |
2010 | D | 2010D | 2000 | 9000 | 22.22% |
I have year and portfolio and the corresponding value as shown above.
In the column, Year-Portfolio summary, I need to show the total sum for the respective year and portfolio so that I can check the percentage of this value for the whole of the portfolio for that year.
Eg. for 2009 and product A, the sum of values = 100+200+300+400+500 = 1500 - which is shown in Summary - Portfolio - Year
This has to happen for all respective year and portfolio.
I know it should be something achievable but somehow I am not able to figure out how to do it.
I could do it on excel -- see attachment, but not on qlikview.
Please help.
Thanks,
Bino.
Hi All,
I have similar request like above. @Anonymous @Miguel_Angel_Baeyens @IAMDV @Anonymous @saranshbh
For Total Meeting i gave formula: =sum(Total <Month, Name> Meeting1 ) But in Total Meeting all columns I am not getting summation of this grouping. Could you please check what is the issue.
Year | Month | Name | Meeting1 | Total Meeting |
10 | ||||
2020 | Jan | Amita | 3 | 3 |
2020 | Feb | Amita | 0 | 0 |
2020 | Mar | Amita | 0 | 0 |
2020 | Apr | Amita | 0 | 0 |
2020 | May | Amita | 0 | 0 |
2020 | Jun | Amita | 0 | 0 |
2020 | Jul | Amita | 0 | 0 |
2020 | Jan | Heena | 1 | 1 |
2020 | Feb | Heena | 0 | 0 |
2020 | Mar | Heena | 0 | 0 |
2020 | Apr | Heena | 0 | 0 |
2020 | May | Heena | 0 | 0 |
2020 | Jun | Heena | 0 | 0 |
2020 | Jul | Heena | 0 | 0 |
Thanks in advance!
Hi All,
I tried =sum(Total <Name> Meeting1 ) and it worked. To summarize this i think we need to put columns on which we want to do grouping inside closed "<>" Thanks!
Year | Month | Name | Meeting1 | Total Meeting |
10 | ||||
2020 | Jan | Amita | 3 | 3 |
2020 | Feb | Amita | 0 | 3 |
2020 | Mar | Amita | 0 | 3 |
2020 | Apr | Amita | 0 | 3 |
2020 | May | Amita | 0 | 3 |
2020 | Jun | Amita | 0 | 3 |
2020 | Jul | Amita | 0 | 3 |
2020 | Jan | Heena | 1 | 1 |
2020 | Feb | Heena | 0 | 1 |
2020 | Mar | Heena | 0 | 1 |
2020 | Apr | Heena | 0 | 1 |
2020 | May | Heena | 0 | 1 |
2020 | Jun | Heena | 0 | 1 |
2020 | Jul | Heena | 0 | 1 |