Conditional Expression Calculation

klaus_feldam — Wed, 30 Jul 2014 17:05:14 GMT

Need some Qlik guru help for what should be a fairly simple issue.

Basically, I am looking at performing calculations on a set of records, but ONLY if the record count is greater than 1.

I don't want the calculation to include the records where I only have one record.

Example:

Core table contents:

ID	StartDate
12	February 17, 2014
12	March 18, 2014
13	March 16, 2014
14	May 23, 2014

ID is not a unique record, but the combination of ID and Start Date is unique

Count (ID&StartDate):

ID	StartDate	Record Count
12	February 17, 2014	2
13	March 18, 2014	1
14	March 16, 2014	1

Now, in my table, I only want to show the Min/Max Start Dates if my record count is > 1.

Simple, yes!? However, I need to get my Qlik money back. In a regular table, I can use the Dimension Limits and restrict the values to only show greater than 1, but really need to see this in a pivot table. I have been looking at it all morning, and can't find the best way to do this in a pivot table.

Looking forward to some great ideas.

Re: Conditional Expression Calculation

JonnyPoole — Wed, 30 Jul 2014 17:30:07 GMT

How is this ?

i used a conditional expression to check if your cell will have > 1 record. If not, it evaluates to null and the chart properties / presentation tab suppresses these records as null or missing.

if(count([Transaction ID])>1,count([Transaction ID]))

topic Conditional Expression Calculation in QlikView

Conditional Expression Calculation

Re: Conditional Expression Calculation