# Qlik Sense App Development

New Contributor II

## excluded companies

Dear all

I have a barchart with excluded companies over time. What I want to show is a table with the new excluded companies in a period.

Example:

In June I have 10 excluded companies in July 12 excluded companies. What I want to see in a table are the names of the 2 new excluded companies.

For the barchart I use the following formula: Count({1<ULTIMO_DATE>} distinct [company ])

Best regards

Xandro

1 Solution

Accepted Solutions
MVP

## Re: excluded companies

Perhaps in a table with ULTIMO_DATE as a dimension, use this for the company dimension:

=Aggr(If(Count(TOTAL ULTIMO_DATE) = 1, company), company)

6 Replies
MVP

## Re: excluded companies

Its not clear what you mean by 'excluded' here. I assume you have a date field to identify "June customers" and "July customers"? I suggest that you post a small sample qvf file with some representative data and your expected output.

New Contributor II

## Re: excluded companies

Dear Jonathan

I will rephrase my question

I have a barchart with companies over time. What I want to show is a table with the new companies in a period.

Example:

In June I have 4 companies (AA,BB,CC,DD). In July I have 6 companies (AA,BB,CC,DD,EE,FF). What I want to see in a table are the names of the 2 new companies (EE,FF).

For the barchart I use the following formula: Count({1<ULTIMO_DATE>} distinct [company ])

Best regards

Xandro

 ULTIMO_DATE company 30-Jun AA 30-Jun BB 30-Jun CC 30-Jun DD 31-Jul AA 31-Jul BB 31-Jul CC 31-Jul DD 31-Jul EE 31-Jul FF 31-Jul EE FF

MVP

## Re: excluded companies

Perhaps in a table with ULTIMO_DATE as a dimension, use this for the company dimension:

=Aggr(If(Count(TOTAL ULTIMO_DATE) = 1, company), company)

New Contributor II

## Re: excluded companies

Jonathan

Thanks, this works fine.

New Contributor II

## Re: excluded companies

Jonathan

Sorry, I was to fast with my answer. I get now all the names and not the new names.

Best regards

Xandro

MVP

## Re: excluded companies

Then I suggest you upload a sample qvf file with some representative data. Someone else may be able to assist (I don't have a current version of QS on ths PC).

You may want to create a new post as this one was marked answered. You can reference this thread on the new post.

excluded companies