Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

akuttler
Contributor

Dates repeating in Pivot Table

Hi, I have a pivot table with "Transaction Date" Row Field and a measure "Total Payments Posted"

The expression for "Total Payments Posted" is (Sum({<ITEMTYPE={'I-P','P-P','P'}>}Trans))*-1

Where item type is another field that represents payment type, and trans represents the amount. Payments are negative in the database so I Multiply by -1 so the total will appear as a positive in the visualization.

However, I cant figure out why the dates are repeating in my visualization?

I am connected to 4 database tables all having the same field names and concatenated in my data load script.

Thanks in Advance.

Capture.PNG

1 Solution

Accepted Solutions

Re: Dates repeating in Pivot Table

Your date might be a timestamp... convert it into a date field like this

Date(Floor("Transaction Date")) as "Transaction Date"

2 Replies

Re: Dates repeating in Pivot Table

Your date might be a timestamp... convert it into a date field like this

Date(Floor("Transaction Date")) as "Transaction Date"

akuttler
Contributor

Re: Dates repeating in Pivot Table

Yes! Thank you that solved the problem.

Community Browser