Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
sammie0808
Contributor III
Contributor III

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

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:

HousesColor of House
1white
3blue
2brown
4white

Results wanted below:

HousesColor of HouseTotal Houses% of Houses by Color
1white1010.00%
3blue1030.00%
2brown1020.00%
4white1040.00%
2 Replies
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
Contributor III
Contributor III
Author

Thank you. I will try this

Sent from my iPad