How to get correct total

[#1]

Hi qlikers

PFA

here i used calc dimension as

=Aggr(

Dual(

(Time(Floor([Time In],1/"Interval Size"),'h:mm:ss TT')&'-'&Time(Ceil([Time In]+0.0000001,1/"Interval Size"),'h:mm:ss TT')),

Floor(Frac([Time In]),1/"Interval Size")),[Time In])

and given label name as interval

date,employee id are existed field names

and count(employee id ) as Expresion with count as label

in this i used partial sum for date

here i want in interval 5:30 to 5:40 total as 2 instead of 1

how to get

[#2]

any one is their to help

[swuehl]

Are you using

Count([empoyee id])

or

Count(Distinct [employee id])

as expression?

You would need a sum-of-rows partial sum if you used latter expression, and to create a sum-of-rows in a pivot table, you would need to use advanced aggregation.

But advanced aggregation can't use a calculated dimension like your time interval calculation.

You absolutely need dynamic interval sizing or can you calculate the intervals in your script?

Could you upload a small sample QVW, which makes it easier to create a solution for your?

[jagan · Accepted solution]

Hi,

If you Count([empoyee id]) you will get the expected result, can you attach the sample Qlikview file, so that it would be easier to understand the issue.

Regards,

Jagan.

[HirisH_V7]

Hi please attach sampel app for more info ...

Thanks,

HirisH

[#6]

by using count(employee id) in expression i am getting the right results