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

Associate expression data

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))

1 Solution

Accepted Solutions
sunny_talwar

Try this expression:

=Aggr(If(

RangeSum(

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

+

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

View solution in original post

8 Replies
Anonymous
Not applicable
Author

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
Specialist II
Specialist II

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
Not applicable
Author

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
Not applicable
Author

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

sunny_talwar

Try this expression:

=Aggr(If(

RangeSum(

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

+

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