Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

tmumaw
Valued Contributor

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])) 

Tags (1)
1 Solution

Accepted Solutions

Re: Total Line beside Details

May be this

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

View solution in original post

4 Replies

Re: Total Line beside Details

May be this

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

View solution in original post

Re: Total Line beside Details

Perhaps (TOTAL <FieldName> ....)

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
Valued Contributor

Re: Total Line beside Details

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

Re: Total Line beside Details

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