topic Re: Cross Join in QlikView

Cross Join

Thu, 20 Oct 2016 14:22:04 GMT

Hello,

I am trying to calculate a new value by multiplying two fields from 2 different tabs of the excel input. The sample QVW file and the Excel input are attached here. Please give me your suggestions.

Please let me know if more information is needed.

Expected Output:

Actual Value is from the Sheet:Forecast Final

Percentage from Sheet:Allocation Percentage Final

Thanks.

Re: Cross Join

sunny_talwar — Thu, 20 Oct 2016 17:01:08 GMT

Not very clear as to what you are looking to do. Can you may be explain what you are looking to do?

Re: Cross Join

Thu, 20 Oct 2016 17:16:55 GMT

Sunny,

My input data is split across 2 tabs of Excel input.So my requirement is to get the values from "Forecast Final" sheet for a combination of Country Code and Year Month and split it across the dates from the sheet "Allocation Percentage Final" by multiplying it.

For example, from the picture below, the forecast amount from "Forecast Final" sheet should be multiplied with the data column so that the full amount for that particular Year Month gets split across dates for that month.

Thanks.

Re: Cross Join

Sat, 22 Oct 2016 11:10:01 GMT

Hello, any suggestion to achieve is highly appreciated.

Thanks.