Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.
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.
What is CT_KEY? You need to provide more details and preferably a sample to be able to help you better here
Please see example attached, CT_KEY replaced by 'GENRE'
Is this needed after a selection has been made?
Yes, the selection generates results within the table, where this is required to show which selection generated which results.
Have you tried this