topic Re: How to get correct total in QlikView

How to get correct total

Sun, 22 Nov 2015 07:19:29 GMT

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

Re: How to get correct total

Sun, 22 Nov 2015 09:31:51 GMT

any one is their to help

Re: How to get correct total

swuehl — Sun, 22 Nov 2015 12:57:11 GMT

Are you using

Count([empoyee id])

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?

Re: How to get correct total

jagan — Mon, 23 Nov 2015 04:06:57 GMT

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.

Re: How to get correct total

HirisH_V7 — Mon, 23 Nov 2015 04:16:56 GMT

Hi please attach sampel app for more info ...

Thanks,

HirisH

Re: How to get correct total

Mon, 23 Nov 2015 10:45:52 GMT

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