Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have to replicate in qlikview the following excel table:
where % is, for activity a1 to a6, related to "Tot A" and for activity a7 is related to "Tot B"
I have a qlik table with activity a1 to a8 with value h but I not able to find % per row, do I have to use something like "aggr"?
thank you in advance
Hi Carlo,
I attach a document about your question.. 2 create two pivot table for 2 different scenarios to calculate %.
i hope it will help you..
BR
Omer
Hi all,
I have to replicate in qlikview the following excel table:
-------------------------------------------------------------
| activity | h | % |
-------------------------------------------------------------
| a1 | 862,00 | 49,91% |
| a2 | 100,00 | 5,79% |
| a3 | 264,00 | 15,29% |
| a4 | 42,00 | 2,43% |
| a5 | 91,00 | 5,27% |
| a6 | 368,00 | 21,31% |
| Tot A |1727,00| |
| a7 | 157,00 | 8,33% |
| Tot B |1884,00| |
| a8 | 257,00 | |
| Tot |2141,00| |
-------------------------------------------------------------
where % is, for activity a1 to a6, related to "Tot A" and for activity a7 is related to "Tot B"
I have a qlik table with activity a1 to a8 with value h but I not able to find % per row, do I have to use something like "aggr"?
thank you in advance
Hi Carlo,
I attach a document about your question.. 2 create two pivot table for 2 different scenarios to calculate %.
i hope it will help you..
BR
Omer
It works! the first scenario is what I was needing
Thank you very much for the time you spent on this.
Kind regards
Carlo A.