topic How to create a Chart with a Pivot Table in QlikView https://community.qlik.com/t5/QlikView/How-to-create-a-Chart-with-a-Pivot-Table/m-p/1115436#M920379 <HTML><HEAD></HEAD><BODY><P>I am trying to create a chart that contains a Pivot table.&nbsp; I am trying to count the number of transactions by person on a given day.&nbsp; However, I only want to show the occurrences when there are multiple transactions in a given day by the same person.&nbsp; I do not wish to see the single transactions on a given day.&nbsp; So, if a person made more than one transaction on a day, those are the ones I want to display.&nbsp; How can I do this?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT cliff_clayman 2020-11-25T16:16:04Z How to create a Chart with a Pivot Table https://community.qlik.com/t5/QlikView/How-to-create-a-Chart-with-a-Pivot-Table/m-p/1115436#M920379 <HTML><HEAD></HEAD><BODY><P>I am trying to create a chart that contains a Pivot table.&nbsp; I am trying to count the number of transactions by person on a given day.&nbsp; However, I only want to show the occurrences when there are multiple transactions in a given day by the same person.&nbsp; I do not wish to see the single transactions on a given day.&nbsp; So, if a person made more than one transaction on a day, those are the ones I want to display.&nbsp; How can I do this?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-Chart-with-a-Pivot-Table/m-p/1115436#M920379 cliff_clayman 2020-11-25T16:16:04Z Re: How to create a Chart with a Pivot Table https://community.qlik.com/t5/QlikView/How-to-create-a-Chart-with-a-Pivot-Table/m-p/1115437#M920380 <HTML><HEAD></HEAD><BODY><P>Not really sure about your requirements, maybe like this</P><P></P><P>- Create a pivot table chart</P><P>-Two dimensions, Persion and Day / Date</P><P>- 1 expression:</P><P>=If(Count(DISTINCT TransactionID)&gt;1, Count(DISTINCT TransactionID))</P></BODY></HTML> Tue, 10 May 2016 21:08:52 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-Chart-with-a-Pivot-Table/m-p/1115437#M920380 swuehl 2016-05-10T21:08:52Z Re: How to create a Chart with a Pivot Table https://community.qlik.com/t5/QlikView/How-to-create-a-Chart-with-a-Pivot-Table/m-p/1115438#M920381 <HTML><HEAD></HEAD><BODY><P>Based on you criteria, I created a sample file and attached here. Hope this helps..</P></BODY></HTML> Tue, 10 May 2016 21:09:00 GMT https://community.qlik.com/t5/QlikView/How-to-create-a-Chart-with-a-Pivot-Table/m-p/1115438#M920381 trdandamudi 2016-05-10T21:09:00Z