Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

Sales Launch Report - Possible in QV?

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?

Screen shot 2012-08-02 at 12.49.11.png

6 Replies
Not applicable

Re: Sales Launch Report - Possible in QV?

check above/below function

Not applicable

Re: Sales Launch Report - Possible in QV?

or post a sample file

RSvebeck
Valued Contributor

Re: Sales Launch Report - Possible in QV?

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

Svebeck Consulting AB
Not applicable

Re: Sales Launch Report - Possible in QV?

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

Not applicable

Re: Sales Launch Report - Possible in QV?

Thanks - I'll investigsate

RSvebeck
Valued Contributor

Re: Sales Launch Report - Possible in QV?

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

Svebeck Consulting AB