Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

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
Highlighted

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
Highlighted
Creator III
Creator III

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

Highlighted

Can you provide a sample to look at?

Highlighted
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

Highlighted

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.

Highlighted
Creator III
Creator III

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.

Highlighted

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

Highlighted
Creator III
Creator III

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

Highlighted

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