I have a question regarding the total count function

sserdardemirr — Thu, 17 Feb 2022 14:10:36 GMT

Hi,

I'm new to QlikSense and I have a question regarding the total count function that I want to apply to a table cells.
I have uploaded images in this post.
There are 2 dates and 2 status.

I would like to show the records going from open to closed from the Date1 to Date2 by decrement on Table2

and

ı added the "Total" calculation field on Table2.

Formula :
=IF(DATE1>DATE2,null(),
IF(DATE1<DATE2,count({<"Status1"={'open'},"Status2"={'close'}>}[Product])
, count({<"Status1"={'open'}>}[Product])))

Can you help me with the formula below for the calculation I want to create table in the 2.JPG?

additionally: i tried count total function but its counting all numbers

Thanks in advance.

Re: I have a question regarding the total count function

Claude1 — Fri, 25 Feb 2022 04:14:22 GMT

@sserdardemirr wrote:

Hi,

I'm new to QlikSense and I have a question regarding the total count function that I want to apply to a table cells.
I have uploaded images in this post.
There are 2 dates and 2 status. Thirty One Today

I would like to show the records going from open to closed from the Date1 to Date2 by decrement on Table2

and

ı added the "Total" calculation field on Table2.

Formula :
=IF(DATE1>DATE2,null(),
IF(DATE1<DATE2,count({<"Status1"={'open'},"Status2"={'close'}>}[Product])
, count({<"Status1"={'open'}>}[Product])))

Can you help me with the formula below for the calculation I want to create table in the 2.JPG?

additionally: i tried count total function but its counting all numbers

Thanks in advance.

It's understandable that you see all dimension values, since you cleared the selection in Answer field in the set expression.

Try multiplying your existing expression with an expression that return 1 for the selected values and 0 for the excluded:

=sum( total <Question, Survey> {<Answer>} aggr(count( {<Answer>}Answer),Survey, Answer))* COUNT(DISTINCT 1)

topic I have a question regarding the total count function in QlikView

I have a question regarding the total count function

Re: I have a question regarding the total count function