Aggregation on Dimension

[Clever_Anjos]

I have a dataset like Excel attached (please refer to Help with Set Analysis and aggregation‌‌ as requirement)

stalwar1‌ brightly helped me to find a way of creating my expression to find

(aggregated on [ID Som]) how many segments have a [ID Som] that have a segment = Silence of Duration between 22  and  66 (example) and also have segments = MUSIC of duration between 5 and 20.

In this sample I should have:

• 787 - 4
• 882 - 0 (It has SILENCE but hasn´t MUSIC)

Now I have to create a graph like this

how many [ID Som] have 2 segments, ow many [ID Som] have 3 segments and so on.

Any idea how to solve this?

[sunny_talwar]

Check if the attached meets your requirement?

[sunny_talwar · Accepted solution]

Updated sample

[Clever_Anjos]

stalwar1‌, you really deserve to be at Qlik Mount Olympus

[sunny_talwar]

Where is that taking place, I am in

[Anonymous]

Could you please also post the expression in this thread, so I can also learn.

No Qlik View and can not open the attached file.

Thanks!

[Clever_Anjos]

My final expression use some variables but these expression is correct

=Aggr(Count(DISTINCT {<[ID Som] = {"=(Count({<[Tipo Segmento] = {'SILENCE'}, [Duracao Segmento] = {'>=22<=66'}>}[Duracao Segmento]) > 0 and

  Count({<[Tipo Segmento] = {'MUSIC'}, [Duracao Segmento] = {'>=5<=20'}>}[Duracao Segmento]) > 0)"}>*

  (<[Tipo Segmento] = {'SILENCE'}, [Duracao Segmento] = {'>=22<=66'}>+<[Tipo Segmento] = {'MUSIC'}, [Duracao Segmento] = {'>=5<=20'}>)} [ID Segmento]), [ID Som])