Transactional Data

evansabres — Tue, 08 Mar 2016 17:05:45 GMT

Hello -

I am working with a data set that has transactional data. The file is overwritten daily with the sales from the previous day.

My date field is called [Event Date Time] and my transaction date field is called [Trans Date] I also have several buyer types, with the filed being names [Buyer Type Code] with those being called 'STH' 'Adult' etc...

What I want to be able to do is, in my stacked bar chart that has the different buyer type codes, build into the expression a condition that only references after a certain date.

Currently, my expression is : =SUM({$<promoCDE={"Adult"}>}[Net Sold Qty])

I would like to add a condition after that only allows data from after the [Trans Date] of 9/18.

Thank you

Re: Transactional Data

swuehl — Tue, 08 Mar 2016 17:38:10 GMT

If Trans Date is formatted like 'M/D/YYYY', maybe like

=SUM({$<promoCDE={"Adult"}, [Trans Date]= {">=9/18/2015"}>} [Net Sold Qty])

Dates in Set Analysis

topic Transactional Data in QlikView

Transactional Data

Re: Transactional Data