Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Straight table with "artificial" column for market penetration

Hi,

I would like to create a table which shows the market penetration of my company's product based on the annual revenue of the client company. For example, if i have closed a deal with Subsidiary A1(Annual Revenue of 2000) and A2(Annual Revenue of 1000) but failed to close a deal with A3(4000), I would have achieved a penetration of 42.8% (3000/7000) of HQ A.

How should I go about creating column ⑤and ⑥?

I have uploaded a sample file as well.

Thanks!

Market Penetration.png

1 Solution

Accepted Solutions
rubenmarin

4 Replies
Not applicable
Author

Hi Minghui,

Is it helpful for u?

Here i am using pivot table

Untitled.png

for the sub total

Untitled.png

for the percentage of    6th column

Untitled.png

rubenmarin

Not applicable
Author

Great help! The aggr() function which you used was extremely helpful to achieve what i wanted to.

Not applicable
Author

Thank you for the help!