topic Re: Sales Launch Report - Possible in QV? in QlikView

Sales Launch Report - Possible in QV?

Thu, 02 Aug 2012 11:57:06 GMT

I'm trying to create a product launch report in QV that allows me to compare how fast sales performed by month by country.

Its not a simple line chart, as a product is launched at different times (Jan for UK / Mar for Spain and maybe Apr for Italy). So want to align all the months to a single start point to see the sales velocity – see screen shot. You can see the x-axis is Month 0 / Month 1 / Month 2 etc

Is this possible in QV?

Re: Sales Launch Report - Possible in QV?

Thu, 02 Aug 2012 13:06:06 GMT

check above/below function

Re: Sales Launch Report - Possible in QV?

Thu, 02 Aug 2012 13:06:58 GMT

or post a sample file

Re: Sales Launch Report - Possible in QV?

RSvebeck — Thu, 02 Aug 2012 13:08:55 GMT

You should in the load script create a calculated field like "number of days from launch". And then base your x-axis on that field.

Best Regards

Robert

Re: Sales Launch Report - Possible in QV?

Thu, 02 Aug 2012 16:30:13 GMT

I'd like to create an expression on a chart to produce the result - Since I have multiple product launches.

Re: Sales Launch Report - Possible in QV?

Thu, 02 Aug 2012 16:32:26 GMT

Thanks - I'll investigsate

Re: Sales Launch Report - Possible in QV?

RSvebeck — Fri, 03 Aug 2012 07:52:38 GMT

Not 100% sure if this works for your data, but perhaps a solution with a calulated dimension (using the valueloop function) and then an expression which caluculates the date difference between launch date and transaction date and checks that number agains the valueloop dimension.

See attatched example of this kind of solution.

If it works, I'd still recomend to try to so a solution into the script if you have lots of data, because I think using dynamic dimensions and if expressions will be slow to work with for the end user if data is huge.

Regards,

Robert