topic Re: Previous Day Sales in QlikView

Previous Day Sales

evansabres — Wed, 01 Mar 2017 15:59:00 GMT

I am trying to figure out 'Day of Event Sales' for events.

My fields are:

nwEVENTDTE (formatted as 10/13/2016)

Trans Date (formatted as 10/13/2016)

Net Sold Qty (numeric value)

I want to be able to take the final [Net Sold Qty] for a nwEVENTDTE and subtract out what the [Net Sold Qty] was on the previous day, giving me a 'day of sales' figure

Example:

nwEVENTDTE = 10/13/2016

Final [Net Sold Qty] = 18,000

[Net Sold Qty] as of [Trans Date] 10/12/2016 = 17,500

'Day of Game Sales' = 500

Any suggestions would be appreciated.

Re: Previous Day Sales

sunny_talwar — Wed, 01 Mar 2017 16:03:54 GMT

Are you trying to do this in a text box or straight table? if it is a table, what are your dimensions?

Re: Previous Day Sales

evansabres — Wed, 01 Mar 2017 16:10:52 GMT

A table. Dimension would be nwEVENTDTE (formatted as 10/13/2016)

Re: Previous Day Sales

sunny_talwar — Wed, 01 Mar 2017 16:14:20 GMT

May be this

if table is sorted by ascending values of nwEVENTDTE

Sum([Net Sold Qty]) - Above(Sum([Net Sold Qty]))

if table is sorted by descending values of nwEVENTDTE

Sum([Net Sold Qty]) - Below(Sum([Net Sold Qty]))

Re: Previous Day Sales

evansabres — Wed, 01 Mar 2017 18:28:51 GMT

This does not provide the value I am looking for. This is taking the [Net Sold Qty] for the nwEVENTDTE of 10/13/16 and subtracting the [Net Sold Qty] for the nwEVENTDTE of the previous game.

What I am trying to do is find the [Net Sold Qty] for a nwEVENTDTE the day before the nwEVENTDTE, which would be found in the field [Trans Date]

So, on transDATE 10/12/2016 there were 17,500 tickets distributed ([Net Sold Qty]) for nwEVENTDTE 10/13/16 and on transDATE 10/13/16 there were 18,000 ([Net Sold Qty]) tickets distributed.

I would call this total 'Day of Game Sales'

Re: Previous Day Sales

sunny_talwar — Wed, 01 Mar 2017 18:30:03 GMT

Can you share a screenshot of your chart? Do you have more than one dimension?

Re: Previous Day Sales

evansabres — Wed, 01 Mar 2017 18:31:54 GMT

The only dimension I would be using is nwEVENTDTE (formatted as 10/13/2016)

I haven't created the chart yet, so unfortunately no screenshot

Re: Previous Day Sales

sunny_talwar — Wed, 01 Mar 2017 18:32:53 GMT

Then how do you know what I have given isn't working?

Re: Previous Day Sales

evansabres — Wed, 01 Mar 2017 18:37:08 GMT

I meant that I had not created a functioning chart yet

Re: Previous Day Sales

sunny_talwar — Wed, 01 Mar 2017 18:40:46 GMT

I think you are using this

Sum([Net Sold Qty]) - Below(Sum([Net Sold Qty]))

Try this instead

Sum([Net Sold Qty]) - Above(Sum([Net Sold Qty]))

Re: Previous Day Sales

evansabres — Wed, 01 Mar 2017 18:43:04 GMT

I tried both, however still wrong I need to reference the [Trans Date] which is another field. For nwEVENTDTE of 10/13/2016, I want to know the [Net Sold Qty] as of [Trans Date] 10/12/2016

Re: Previous Day Sales

sunny_talwar — Wed, 01 Mar 2017 18:45:26 GMT

Oh okay, I guess unless I see a sample, I might not be able to offer too much help. If you are unable to share a sample, I hope someone else might be able to help you out.

Best,

Sunny

Re: Previous Day Sales

evansabres — Wed, 01 Mar 2017 18:59:48 GMT

THis is an example of how the data appears within the application.