Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Calculating % for specific combinations

I have a dataset listing events happening at a plant:

schermbron.jpg

the goal is:

- find cases where A+B happened on the samen day at a plant

- calculated the % of the total of events at that plant

schemresult.jpg

Grouping in the script is not the way to go, as there are other details in the dataset that need to be analysed.

Any hints on how to achieve this ?

1 Solution

Accepted Solutions
MVP
MVP

Re: Calculating % for specific combinations

You could calculate your A+B same day column using this expression:

=sum(aggr(if(count(distinct event)=2,1,0),plant,date))

Hope this helps,

Stefan

1 Reply
MVP
MVP

Re: Calculating % for specific combinations

You could calculate your A+B same day column using this expression:

=sum(aggr(if(count(distinct event)=2,1,0),plant,date))

Hope this helps,

Stefan