Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

How to create a Chart with a Pivot Table

I am trying to create a chart that contains a Pivot table.  I am trying to count the number of transactions by person on a given day.  However, I only want to show the occurrences when there are multiple transactions in a given day by the same person.  I do not wish to see the single transactions on a given day.  So, if a person made more than one transaction on a day, those are the ones I want to display.  How can I do this?

1 Solution

Accepted Solutions
Highlighted
Master II
Master II

Based on you criteria, I created a sample file and attached here. Hope this helps..

View solution in original post

2 Replies
Highlighted
MVP
MVP

Not really sure about your requirements, maybe like this

- Create a pivot table chart

-Two dimensions, Persion and Day / Date

- 1 expression:

=If(Count(DISTINCT TransactionID)>1, Count(DISTINCT TransactionID))

Highlighted
Master II
Master II

Based on you criteria, I created a sample file and attached here. Hope this helps..

View solution in original post