Associate expression data

[Anonymous]

I have an expression in a bar chart that displays a count of customers. I would like create a straight table that allows me to see the detail behind the expression. For example, 201607 there are 49,998 customers. How can I create a listbox to capture those individuals.

=If(STARTDATE_YYYYMM >= Max(TOTAL STARTDATE_YYYYMM, 6), Below(RangeSum(Below(Count({<ENROLLMENT_STATUS = {'Open'}>}ID), 0, NoOfRows() - RowNo() + 1))) + Count(ID))

[Anonymous]

Assuming I can create a list box expression. I just copied and pasted my chart expression but I don't see results.

[sunny_talwar]

Can you provide a sample to look at?

[qliksus]

Do you want to display the numbers in the table as a list like something below?

Not sure if this is what you are looking at

[ramasaisaksoft]

Hi Mrjohn,

Create a STable in that ENROLLMENT_STATUS ,Customer ID,Custermer Name...etc and  your Expression

(=If(STARTDATE_YYYYMM >= Max(TOTAL STARTDATE_YYYYMM, 6), Below(RangeSum(Below(Count({<ENROLLMENT_STATUS = {'Open'}>}ID), 0, NoOfRows() - RowNo() + 1))) + Count(ID)))

i hope it will gives the all 49,998  customers individually.

else

create  Straight table with customer details fields,your expression,2nd Expression as =1,List box (ENROLLMENT_STATUS ) select the Open option.

it will gives your result.

[Anonymous]

See attached. I would like to see the details behind the numbers on the chart. I created a straight chart and added my details but when I select the number in the chart my straight table does not match.

[sunny_talwar]

Is the issue still open? I saw it getting closed in the morning?

[Anonymous]

It was accidentally mark closed but is still open as my issues is not resolved.

[sunny_talwar · Accepted solution]

Try this expression:

=Aggr(If(

RangeSum(

Count({<Status = {'Open'}>}ID)

+

Count({<STARTDATE_YYYYMM = {$(=Max(STARTDATE_YYYYMM))}>} ID)) > 0, ID), ID)