topic Re: Associate expression data in QlikView

Associate expression data

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Associate expression data

Anonymous — Mon, 25 Jul 2016 21:35:17 GMT

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

Re: Associate expression data

sunny_talwar — Mon, 25 Jul 2016 22:22:05 GMT

Can you provide a sample to look at?

Re: Associate expression data

qliksus — Tue, 26 Jul 2016 03:41:24 GMT

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

Re: Associate expression data

ramasaisaksoft — Tue, 26 Jul 2016 07:16:18 GMT

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.

Re: Associate expression data

Anonymous — Tue, 26 Jul 2016 13:05:23 GMT

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.

Re: Associate expression data

sunny_talwar — Tue, 26 Jul 2016 13:31:09 GMT

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

Re: Associate expression data

Anonymous — Tue, 26 Jul 2016 13:39:40 GMT

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

Re: Associate expression data

sunny_talwar — Tue, 26 Jul 2016 17:55:16 GMT

Try this expression:

=Aggr(If(

RangeSum(

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

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