Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

bitaneyim
Contributor

Table Chart Calculated Total in Additional Field

Hi Guys,

I want to show in a table chart following total field:

Data:

PersonWorking HoursCostsMonth
P135100003.2017
P136130004.2017
P13190005.2017
P245100003.2017
P254200004.2017

Month03.201704.201705.2017
Personsum(Costs)sum(Costs)sum(Costs)
Total (Working Hours)809031
Total (Costs)20003300900
P110001300900
P220002000-

I know how I can show Total sum of Costs, but how can I show Total sum of Working Hours without a column in Expressions?

1 Solution

Accepted Solutions

Re: Table Chart Total Additional Field

May be this?

Capture.JPG

Life is so rich, and we need to respect to the life !!!
4 Replies

Re: Table Chart Total Additional Field

May be this?

Capture.JPG

Life is so rich, and we need to respect to the life !!!
bitaneyim
Contributor

Re: Table Chart Calculated Total in Additional Field

Hi Anil,

this is good. But what exactly do you make with Dim and why Dim is from 1-3?

Re: Table Chart Calculated Total in Additional Field

To customize the special adding(not existing the rows) for special rows, I am creating sequential numbers using Dim which has 1,2,3 because In UI it showing Person, Costs, Hours. That means i am allocating to each Dim value to Person and Costs and Hours. After that i made expression to fit each dim of all measures for customize one..

Does it make sense ??

Note - Please mark it as helpful and Correct answer when applicable.

Life is so rich, and we need to respect to the life !!!
bitaneyim
Contributor

Re: Table Chart Calculated Total in Additional Field

Hi Anil,

yes I understand. it's perfect. Many Thanks

Community Browser