Discussion Board for collaboration related to QlikView App Development.
Hello, I am just a business self service user, not a programmer. I am using Qlikview 11. Below is a simple example of what like to do:
I would like to know how to add the "Total Houses" (sum of houses) column and "% of Houses by Color Column" (number of each color of house divided by "total houses"
Results wanted below:
LOAD * INLINE [
Houses, Color of House
LOAD Sum(Houses) as [Total Houses]
Num([Houses]/[Total Houses], '##.00%') as [% of Houses by Color]
DROP Table Table;
Thank you. I will try this
Sent from my iPad