Percentage Subtotal

[kfahri342]

Hi All,

Is there a way to create table like this on Qlikview.

I need to be able to show the count Total and % Total of this table [i.e. the last two rows]. Is this achievable?

Many Thanks

Kozan

Name	Week 1	Week 2	Week 3	Grand Total
Steve	50	50	100	200
John	80	85	65	230
Emily	20	60	80	160
Grand Total	150	195	245	590
Grand Total [%]	25%	33%	42%	100 %

[Anonymous]

I can't share this example.

It's data from a customer in my company.

Sorry.

But you can test this in the future.

[sunny_talwar]

Hahahaha I have done testing with this with large amount of data and it never gave me any problems

[Anonymous]

Very strange kkkkk.. when I tested, with large amount of data, there was a big difference.

[sunny_talwar]

Okay

[kfahri342]

Thanks Sunny.

Unfortunately, I am struggling to replicate what you have done on your qvw.doc  [the example I shared with you guys was for demonstration purposes only. As the data I am using is work related and therefore unable to share, but its also a bit more complicated].

Are you able to talk me through a bit more on how your expression works please? As this is where I am failing to understand.

Also, please note the Values I receive are a result of a COUNT IF function, - can you let me know if there are any significant implications on the expression when using this?

[fallenangel6]

This reply saved my day. Thank you Stalwar1