excluded companies

[jjvicenza1930]

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 ])

Could someone give me advise.

Thanks in advance for your reaction.

Best regards

Xandro

[jonathandienst]

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.

[jjvicenza1930]

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 ])

hanks in advance for your reaction.

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

[jonathandienst · Accepted solution]

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)

[jjvicenza1930]

Jonathan

Thanks, this works fine.

[jjvicenza1930]

Jonathan

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

Best regards

Xandro

[jonathandienst]

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