Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

laurent_ankri
New Contributor

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

Tags (4)
4 Replies

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

Hi,

     Try this,

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

         

     For distinct count

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

     Hope it helps,

Not applicable

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

Your syntax is slightly wrong

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

Or

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

laurent_ankri
New Contributor

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

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


laurent_ankri
New Contributor

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

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


Community Browser