Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

maxsheva
Contributor

Share per each dimension

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.

1 Solution

Accepted Solutions

Re: Share per each dimension

Try this

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

or this

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

2 Replies

Re: Share per each dimension

Try this

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

or this

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

maxsheva
Contributor

Re: Share per each dimension

Thank you Sunny!

Community Browser