topic I would like to create a sum if expression in QlikView

I would like to create a sum if expression

Anonymous — Tue, 05 Jul 2016 15:53:56 GMT

I need to create sum if expression for tickets entering month that takes the sum of the count column if [Previous Months Open Count] = 1 and [No Date Closed Task] = 0

Re: I would like to create a sum if expression

sunny_talwar — Tue, 05 Jul 2016 15:56:51 GMT

Which expression are we trying to help you with in the attached sample?

Re: I would like to create a sum if expression

Chanty4u — Tue, 05 Jul 2016 17:03:05 GMT

try

=sum({<(if [Previous Months Open Count] = 1 and [No Date Closed Task] = 0) >}Tickets )

Re: I would like to create a sum if expression

Anonymous — Tue, 05 Jul 2016 17:39:53 GMT

I need help getting the tickets entering month expression located within the pivot table labeled tickets traffic workflow

Re: I would like to create a sum if expression

Anonymous — Tue, 05 Jul 2016 17:43:39 GMT

Thank you but this was not correct. Further, I am trying to take the sum of the count column which can be seen in the table on the main tab. Each count has a value of 1 so based on the parameters of previous months open count and no date closed task I wish to take the sum of the count column which would in turn get me a count of the amount of tickets entering the month.

Re: I would like to create a sum if expression

sunny_talwar — Tue, 05 Jul 2016 17:57:14 GMT

Does this look like what you were looking for?

Expression:

Count(DISTINCT {<[Previous Months Open Count] = {1}, [No Date Closed Task] = {0}, Opened = {"$(='<' & Date(MonthStart(Today()), 'M/D/YYYY h:mm:ss TT'))"}>}Count)

Note: Count is spelled as C capital and not count. Similarly we have Opened and not opened. QlikView is case sensitive and you need to use the correct casing to make sure you see a result