Equation

evansabres — Fri, 20 Mar 2015 17:27:43 GMT

Hello -

I have several fields, prmTIXQTY, filedate and prmBUYERTYPE.

What I want to do is create a chart that shows the number of tickets sold (prmTIXQTY) by all buyer types [prmBUYERTYPE) except one (STH) over the course of time (filedate)

The problem that I am running into is that the data seems to aggregate (keeps adding in some way that I am not sure of) I choose full accumulation and no accumulation and the problem is the same.

Ideally, the data should be:

filedate prmTIXQTY prmBUYERTYPE Sum

10/1 100 Adult 100

10/2 50 Adult 12

So, I want to show that on 10/1 there were 100 tickets sold and on 10/2 there were 50 tickets sold. (Using full accumulation I can show where the number of tickets sold over all is) but I want to shows the number sold each day.

Thank you.

Re: Equation

Gysbert_Wassenaar — Fri, 20 Mar 2015 17:46:29 GMT

It sounds like a straight table with prmBUYERTYPE and filedate as dimensions and sum(prmTIXQTY) should be all you need. If you want to except the buyertype STH then use this expression:

sum({$-<prmBUYERTYPE={'STH'}>}prmTIXQTY).

You don't need to enable accumulation unless you want each rows value to be the sum of the previous rows values and the current one.

topic Re: Equation in QlikView

Equation

Re: Equation