Qlikview 11- how can I add columns and make calculations for those columns

[sammie0808]

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"

Example:

Data:

Houses	Color of House
1	white
3	blue
2	brown
4	white
Results wanted below:
Houses	Color of House	Total Houses	% of Houses by Color
1	white	10	10.00%
3	blue	10	30.00%
2	brown	10	20.00%
4	white	10	40.00%

[sunny_talwar]

Try this:

Table:

LOAD * INLINE [

    Houses, Color of House

    1, white

    3, blue

    2, brown

    4, white

];

Join (Table)

LOAD Sum(Houses) as [Total Houses]

Resident Table;

FinalTable:

LOAD *,

  Num([Houses]/[Total Houses], '##.00%') as [% of Houses by Color]

Resident Table;

DROP Table Table;

[sammie0808]

Thank you. I will try this

Sent from my iPad