Select depending on the value of the selection of another selection list - Nobody yet found the solution - Help

[Anonymous]

Hi,

I have a QV application with few tables which 2 are linked by the column [CONTACT_NUM].

I have joigned the QV application in the discussion.

In the table CV_TOU_CONTACTS_VW I have a column date [YEARMONTH]

In the table CV_TOU_FACTURATION I have a column date [YEARMONTH_SALAIRE]

The 2 tables are linked with the column [CONTACT_NUM]

I have created a chart that returns the number of contact with YEARMONTH=2012-1.

I have detached the chart in order to fix the result (chart in red)

I have selected in the column YEARMONTH_SALAIRE the value '2012-1'

I want to find in the seond chart only the number of CONTACT_NUM that are in the first chart ie find all contacts whose YEARMONTH is equal to the value selected in the column YEARMONTH_SALAIRE

How can I do ?

I have tested the expression sum ({<[YEARMONTH]= {"=[YEARMONTH_SALAIRE]"}>} AFFECTE) but it's doesn't work

Thank you very much

Nobody has yet found a solution to my problem.  Help me pleeeeeeaaaaase

[swuehl]

Are you looking for

=sum ({<COMMERCIAL_FACTURATION= {"=YEARMONTH=YEARMONTH_SALAIRE"} >} AFFECTE)

?

[Anonymous]

Thanks for your response but it doesn't work

It is hard to explain what I want
With an example it will be better
I have the following data for example

	YEARMONTH	YEARMONT_SALAIRE
Jonathan Emsallem	2012-1	2012-1
Jonathan Emsallem	2012-2	2012-1
Jonathan Emsallem	2012-1	2012-2
Jonathan Emsallem	2012-3	2012-3

when I select the value '2012-1' in the list selection YEARMONTH_SALAIRE I want to find rows 1 and 3 only

Thank you for your help

[swuehl]

Maybe then try

=sum ({<YEARMONTH = p(YEARMONTH_SALAIRE) >} AFFECTE)

[#5]

=

if([YEARMONTH]=[YEARMONTH_SALAIRE],COMMERCIAL_FACTURATION)

Input in your dimension this calculated dimension e 'sopress null'.

[swuehl · Accepted solution]

Or maybe you need to clear your selection in YEARMONTH_SALAIRE, too:

=sum ({<YEARMONTH = p(YEARMONTH_SALAIRE),YEARMONTH_SALAIRE= >} AFFECTE)

[Anonymous]

That's perfect

Very Thanks

Just to mean : why do I need to clear the selection in YEARMONTH_SALAIRE ?

[swuehl]

In your above sample, you select '2012-1'  in YEARMONTH_SALAIRE which filters this field.

But you want to get also the third record, which is excluded by your current selection, so you must clear the selection in this field.