topic aggregation on list box in QlikView

aggregation on list box

ReddyQsQv — Sat, 16 Nov 2024 18:14:10 GMT

I have attached the sample data and using that created a straight table and the highlighted is calculated sum(REPEAT_CONTACT_INTERVAL)/sum(REPEAT_CONTACT_CNT)
but the list box should also be aggregated on the same with class (REPEAT_CONTACT_INTERVAL,1,'day') (but this is not aggregated as same as straight table.
could you please help on this?

Re: aggregation on list box

Kushal_Chawda — Wed, 12 Aug 2020 15:04:28 GMT

What is expression you are using in listbox?

Re: aggregation on list box

ReddyQsQv — Wed, 12 Aug 2020 15:31:47 GMT

class (REPEAT_CONTACT_INTERVAL,1,'day')

Re: aggregation on list box

Kushal_Chawda — Wed, 12 Aug 2020 15:53:37 GMT

this seems to be different than what you are using in straight table. Try below

=class(aggr(sum(REPEAT_CONTACT_INTERVAL)/sum(REPEAT_CONTACT_CNT), Dimension1,Dimension2),1,'day')

where Dimension1,Dimension2 are your straight table dimensions. You need to include all straight table dimension in aggr

Re: aggregation on list box

ReddyQsQv — Wed, 12 Aug 2020 16:31:34 GMT

It does not work when selecting any value on the Listbox it does not filter straight table

Re: aggregation on list box

Brett_Bleess — Tue, 25 Aug 2020 18:22:21 GMT

You are likely going to have to attach the QVW file to receive further assistance with things, as folks are going to need to be able to see the data model as well as object and expressions being used... Doubtful you will receive further comments without doing that. If you are worried about sensitive data, you can scramble the values in any fields using the Settings\Document Properties\Scrambling tab settings in the Desktop Client to do that prior to posting it.

Regards,
Brett