Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggr/Set Issue

Hello Everyone,

I am having an issue with aggregation in a chart (or at least that's what I think the problem is). I have simplified the dataset to the following - each line representing a production "load".

StartTimePart
1:00A
1:00B
1:00C
1:30A
2:00D
2:30B
3:00B

The problem is with the first three lines, which form 1 "combined load". How can I make a chart using Part as the dimension that will sum up the "loads", but taking into consideration that the first 3 lines only represent 0.33... of a load. i.e. the graph would show A=1.3333, B=2.3333, C=0.33333 and D=1.

I have tried various forms of set analysis and aggregration, but nothing I've come up with fits the bill. What I've been trying to do is - for each line, 1/Total Lines with the same start time. I just don't know what/if any language there is for that.

Any help is greatly appreciated.

Shawn

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try this

Create a straight table with dimension Part and as expression
=sum(aggr(nodistinct 1.0/count(distinct Part),StartTime))

View solution in original post

2 Replies
swuehl
MVP
MVP

Try this

Create a straight table with dimension Part and as expression
=sum(aggr(nodistinct 1.0/count(distinct Part),StartTime))

Not applicable
Author

Works perfectly. Thank you!!!