Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Or maybe you need to clear your selection in YEARMONTH_SALAIRE, too:
=sum ({<YEARMONTH = p(YEARMONTH_SALAIRE),YEARMONTH_SALAIRE= >} AFFECTE)
Are you looking for
=sum ({<COMMERCIAL_FACTURATION= {"=YEARMONTH=YEARMONTH_SALAIRE"} >} AFFECTE)
?
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
Maybe then try
=sum ({<YEARMONTH = p(YEARMONTH_SALAIRE) >} AFFECTE)
=
if([YEARMONTH]=[YEARMONTH_SALAIRE],COMMERCIAL_FACTURATION)
Input in your dimension this calculated dimension e 'sopress null'.
Or maybe you need to clear your selection in YEARMONTH_SALAIRE, too:
=sum ({<YEARMONTH = p(YEARMONTH_SALAIRE),YEARMONTH_SALAIRE= >} AFFECTE)
That's perfect
Very Thanks
Just to mean : why do I need to clear the selection in YEARMONTH_SALAIRE ?
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.