4 Replies Latest reply: Jun 14, 2012 3:15 AM by Laurent ANKRI

To use results of a selection list in a chart

Laurent ANKRI Jul 4, 2012 11:02 AM

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

qlik_tourisme_test.qvw 5.1 MB

Re: To use results of a selection list in a chart

Mayil Vahanan Ramasamy Jun 13, 2012 11:47 AM (in response to Laurent ANKRI)

Hi,

     Try this,

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

     For distinct count

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

     Hope it helps,
Like Show 0 Likes (0)

Actions
- Re: To use results of a selection list in a chart
  
  Laurent ANKRI Jun 14, 2012 3:15 AM (in response to Mayil Vahanan Ramasamy )
  
  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
  
  Like Show 0 Likes (0)
  
  Actions
Re: To use results of a selection list in a chart

Felim Shanaghy Jun 13, 2012 11:47 AM (in response to Laurent ANKRI)

Your syntax is slightly wrong
COUNT({$<[YEARMONTH_SAL]={'[YEARMONTH]'}>} CONTACT_NUM)
Or
Sum(If (YearMonth=YearMonth_Sale,1,0))
Like Show 0 Likes (0)

Actions
- Re: To use results of a selection list in a chart
  
  Laurent ANKRI Jun 14, 2012 3:15 AM (in response to Felim Shanaghy )
  
  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
  
  Like Show 0 Likes (0)
  
  Actions

Go to original post