topic Share per each dimension in QlikView

Share per each dimension

maxsheva — Wed, 12 Apr 2017 18:24:04 GMT

Hi,

LOAD * INLINE [

Example, Date, Value1, Value2

Example1, 01/02/2017, 70, 70

Example1, 01/04/2017, 80, 80

Example1, 01/07/2017, 50, 30

Example1, 01/09/2017, 30, 50

Example2, 01/12/2017, 70, 70

Example2, 01/15/2017, 80, 80

];

I try to find share for each date in Example

Count(Distinct Date)/Aggr(Count( Distinct Date),Example)

It calculates only for one date value per dimension(Example)

I need share for each date.

Thx.

sunny_talwar — Wed, 12 Apr 2017 18:44:56 GMT

Try this

Count(Distinct Date)/Aggr(NODISTINCT Count( Distinct Date),Example)

or this

Count(Distinct Date)/Count(Distinct TOTAL <Example> Date)

maxsheva — Wed, 12 Apr 2017 19:13:58 GMT

Thank you Sunny!