Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Set up total without being influenced by filtering results

Dear to whom may help ,

I do have a table ( normal ) one or pivot with values and a filter pane.

The values are influenced by the selection of filters.

One of the column has a count and this column i need to duplicate it but it should contain the total values so I can have both filtered values and the total values of the same column : the column is the following:  Count([Support.Due date overdue])

how can I achieve this ?

Thank you in advance

2 Replies
m_schindler
Contributor II

Re: Set up total without being influenced by filtering results

Hello ahlem,

have you tried Count(TOTAL [Support.Due date overdue]) ?


Mathias

OmarBenSalem
Esteemed Contributor

Re: Set up total without being influenced by filtering results

Can you please post an image of what you have and what you want to do?

I think it might smthing like this:

Count({1} [Support.Due date overdue])

Community Browser