Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cmorri1988
Contributor

TOTAL<NO_TABLE_DIM> and AGGR

Hi there,

I am required to use both the TOTAL qualifier and AGGR within one expression.

The trouble is, I don't want to include CT_KEY as a dimension within my table, and am aware I need this for this expression to work.

=sum(TOTAL<NO_TABLE_DIM> Aggr(ID,NO_TABLE_DIM))

Does anyone know of another way to create this expression using AGGR only, so I am able to do this without using the TOTAL qualifier.

Thanks!

Tags (2)
6 Replies

Re: TOTAL<NO_TABLE_DIM> and AGGR

What is CT_KEY? You need to provide more details and preferably a sample to be able to help you better here

cmorri1988
Contributor

Re: TOTAL<NO_TABLE_DIM> and AGGR

Hi Sunny,

Please see example attached, CT_KEY replaced by 'GENRE'

Thanks

cmorri1988
Contributor

Re: TOTAL<NO_TABLE_DIM> and AGGR

example app.

Re: TOTAL<NO_TABLE_DIM> and AGGR

Is this needed after a selection has been made?

cmorri1988
Contributor

Re: TOTAL<NO_TABLE_DIM> and AGGR

Yes, the selection generates results within the table, where this is required to show which selection generated which results.

Thanks

Re: TOTAL<NO_TABLE_DIM> and AGGR

Have you tried this

Only(TOTAL BINDING)

Community Browser