topic Re: Datamodel help ??? in QlikView

Datamodel help ???

amit_saini — Mon, 20 Feb 2017 11:24:31 GMT

Hello Experts,

This Finance requirement is somehow complicated , but I'm sure I will get some help.

Data Source looks like below (Refer Source_Data Tab in attachment)

Not sure how can I deal with Month , Volume Months.....and Net Sales Month by using cross table or some other function.

Target Result required: (Refer Result tab in attachment)

Thanks in advance!

amit_saini — Mon, 20 Feb 2017 11:47:30 GMT

Any Suggestion???

Thanks,
AS

Anil_Babu_Samineni — Mon, 20 Feb 2017 11:56:28 GMT

Is it possible to share the Excel, It seems Transpose only. I don't think how much complex it is

amit_saini — Mon, 20 Feb 2017 11:59:57 GMT

PFA

Mon, 20 Feb 2017 12:29:21 GMT

Hi Amit,

I have an idea for the above result to be produced.

Attached the qvw, Kindly go through it.

If it is the same as you expected, you can use it.

Regards,

Vivek

Anil_Babu_Samineni — Mon, 20 Feb 2017 12:47:20 GMT

May be look this

CrossTable([Month-Names], Sales, 4)

LOAD * FROM

(ooxml, embedded labels, table is Source_Data);

And then Create Pivot Table with the Dimension as

Dim1 ='Sum Of ' & [Month-Names]

Dim2 = Month

Expression is Simple

Sum(Sales)

And then Transpose Month as Vertical - Horizontal. Then Sort where ever you need

sureshsindhigi — Mon, 20 Feb 2017 13:12:43 GMT

Hi Amit,

Please find attached result QVW file, hope this will be working for you're a requirement.Thank you.

Regards,

Suresh Sindhigi