Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

nicklisterman
Contributor

LEFT JOIN raising count due to one to many

I've added some data to my dashboard and the new LEFT JOIN has caused my counts to rise.  This is because it is a one to many relationship.  Is there anyway to tell count to look at a specific table and not consider the join?  I'm trying to avoid distinct because I use a cyclic group for time (month, week, day).

1 Solution

Accepted Solutions

Re: LEFT JOIN raising count due to one to many

Count(), or any other function, can not be limited to a specific table. The workaround is to maintain a separate table with the counter at the desired level of granularity.

-Rob

2 Replies

Re: LEFT JOIN raising count due to one to many

Count(), or any other function, can not be limited to a specific table. The workaround is to maintain a separate table with the counter at the desired level of granularity.

-Rob

nicklisterman
Contributor

Re: LEFT JOIN raising count due to one to many

Thanks, Rob.  I'm going to try to concatenate some fields for distinct count.