topic Re: Multiple Transaction Dates in QlikView

Multiple Transaction Dates

evansabres — Mon, 25 Jan 2016 14:30:39 GMT

Hello -

I have a data set of transactional data, containing sale dates, item types, sales totals, etc. The problem I am running into is for many dates, there are multiple transactions and what I want to do is show a chart that has the date as the dimension and total sales as the expression (or similar) but only show one iteration of each date.

For example, if on January 15th, 2016 there were 19 transactions, I just want to show 1/15/2016 once on the chart.

is this possible?

Thank you.

Re: Multiple Transaction Dates

sunny_talwar — Mon, 25 Jan 2016 14:34:04 GMT

I think your date might look like a date field, but may actually be a timestamp field. You can fix this in the script or you can change it in the chart.

For Script:

Date(Floor(DateField)) as DateField

For Chart use a calculated dimension

Date(Floor(DateField))

Re: Multiple Transaction Dates

swuehl — Mon, 25 Jan 2016 14:34:46 GMT

Just use your date field as dimension and

=Sum(Sales)

as expression. If you still see multiple entries for 1/15/2016, I assume your dates are in fact timestamps.

Then either create a date field in the script, or use a calculated dimension

=Date(Floor( [Sales Date]))