Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

To use results of a selection list in a chart

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

4 Replies
MayilVahanan

Hi,

     Try this,

               = COUNT({<[YEARMONTH_SAL]= {"=[YEARMONTH]"}>} CONTACT_NUM)

         

     For distinct count

               = COUNT({<[YEARMONTH_SAL]= {"=[YEARMONTH]"}>} Distinct CONTACT_NUM)

     Hope it helps,

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Your syntax is slightly wrong

COUNT({$<[YEARMONTH_SAL]={'[YEARMONTH]'}>} CONTACT_NUM)

Or

Sum(If (YearMonth=YearMonth_Sale,1,0))

Anonymous
Not applicable
Author

Hi

Thansks for your suggestion but it doesn't work

If I understand your expression return all the recors where YEARMONTH_SAL= YEARMONTH

What I want is the records from CV_TOU_CONTACTS_VW where YEARMONTH equals to the selection of the list box YEARMONTH_SAL

For example :

I have selected in the list Box YEARMONTH_SAL, the value '2012-1'

I want all the records from CV_TOU_CONTACTS_VW where YEARMONTH=2012-1 independently of the value of YEARMONTH_SAL

Thanks


Anonymous
Not applicable
Author

Hi

Thansks for your suggestion but it doesn't work

If I understand your expression return all the recors where YEARMONTH_SAL= YEARMONTH

What I want is the records from CV_TOU_CONTACTS_VW where YEARMONTH equals to the selection of the list box YEARMONTH_SAL

For example :

I have selected in the list Box YEARMONTH_SAL, the value '2012-1'

I want all the records from CV_TOU_CONTACTS_VW where YEARMONTH=2012-1 independently of the value of YEARMONTH_SAL

Thanks