Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tmumaw
Specialist II
Specialist II

Total Line beside Details

Good Morning All,

I need to create a pivot table with totals beside the details.  Any ideas?  It's putting the same values in all years for Term Emp Co..  I'm using this:

count({<Level2=,Reason=,Job=,Ethnic=,InActive = {1},YTDFlag = {1}>}  Total DISTINCT([Employee Number])) 

1 Solution

Accepted Solutions
sunny_talwar

May be this

Count({<Level2, Reason, Job, Ethnic, InActive = {1}, YTDFlag = {1}>}  TOTAL <YearField> DISTINCT [Employee Number])

View solution in original post

4 Replies
sunny_talwar

May be this

Count({<Level2, Reason, Job, Ethnic, InActive = {1}, YTDFlag = {1}>}  TOTAL <YearField> DISTINCT [Employee Number])

Anil_Babu_Samineni

Perhaps (TOTAL <FieldName> ....)

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
tmumaw
Specialist II
Specialist II
Author

Thanks Sunny....are you going to Qonnections?

sunny_talwar

Not this year. I was there last year, but planning to attend Master Summit later in the year.