Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
maxsheva
Creator II
Creator II

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
sunny_talwar

Try this

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

or this

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

View solution in original post

2 Replies
sunny_talwar

Try this

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

or this

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

maxsheva
Creator II
Creator II
Author

Thank you Sunny!