topic Re: data modeling challenge in QlikView

data modeling challenge

Mon, 17 Jun 2013 18:56:46 GMT

Hi all,

i am new to QV and have a tough data modeling challenge which I am not sure how to solve due to my limited experience with QV.

My user wants to calculate Total Sale Price per Product, as Sales Price multiplied by Quantity of Products sold and multiplied by Discount Reduction, applicable to the year when a product was sold.

Then they want to do comparative analysis by applying reductions from other years.

I know this is very confusing so I put a spreadsheet with some test data and use cases.

The sales table will be pretty big (100MM rows) so I am interested what would be the best way to model this in QV.

If you can give me any ideas or directions, this would be greatly appreciated!

Re: data modeling challenge

Gysbert_Wassenaar — Mon, 17 Jun 2013 19:19:41 GMT

You can use the applymap function to add the PriceReductionModifier to the fact table.

Re: data modeling challenge

Mon, 17 Jun 2013 19:27:28 GMT

hi Gysbert,

thanks for the quick response and example! I do not think though it will address the requirement to give them ability to apply reducitons during analysis - you do that in a load script so if a product was sold in 2010, the total price will be caculated using reduction from 2010 (which is the default).

But then from QV document, they want to apply reduction from 2009 or from 2011 and see how it will improve sales if they would use reductions from previous years -I guess this means you cannot precalculate this during load.

Does it make sense?

Re: data modeling challenge

Thu, 20 Jun 2013 14:30:56 GMT

hi guys, any other ideas? I believe this can be done - just need some ideas and directions how

Re: data modeling challenge

Mon, 24 Jun 2013 15:00:33 GMT

please...can someone at least give me directions? I am not asking for a ready solution, just some ideas