topic Re: Qlikview vs Qlik Sense Sales Formula in QlikView

Qlikview vs Qlik Sense Sales Formula

Wed, 25 Nov 2020 16:16:04 GMT

I am new but can't understand why I can get these formulas to work in Qlik Sense but not in a Qlikview straight table:

Estimated Shipments:

(((Sum(MTD_Sales_Pounds)/Sum(Forecast_Sales_Pounds))-(Avg(Ship_Days_Factor)/[Fiscal_Period_Reporting_Ship_Days]))*Sum(Forecast_Sales_Pounds)*(Fiscal_Period_Reporting_Ship_Days+Fiscal_Period_Reporting_Ship_Days-Avg(Ship_Days_Factor))/Fiscal_Period_Reporting_Ship_Days)+sum(Forecast_Sales_Pounds)

and

Over/Under Forecast:

((((Sum(MTD_Sales_Pounds)/Sum(Forecast_Sales_Pounds))-(Avg(Ship_Days_Factor)/[Fiscal_Period_Reporting_Ship_Days]))*Sum(Forecast_Sales_Pounds)*(Fiscal_Period_Reporting_Ship_Days+Fiscal_Period_Reporting_Ship_Days-Avg(Ship_Days_Factor))/Fiscal_Period_Reporting_Ship_Days)+sum(Forecast_Sales_Pounds))-Sum(Forecast_Sales_Pounds)

The way the formula is written is from Qlik Sense and it provides the correct information. I need the same formula to work in Qlikview, please help!

Thanks!

Re: Qlikview vs Qlik Sense Sales Formula

swuehl — Thu, 23 Jun 2016 22:11:28 GMT

What do you mean with: It doesn't work in QlikView. You get no results, wrong results, QV crashes?

Are you using the same context (for example, same dimensions and selections) in both QV and QS?

Data model is exactely the same?

One possible issue could be that you are not using aggregation functions on all field references:

Use Aggregation Functions!

If possible, post a small sample QVW that demonstrates your issue, please.

Re: Qlikview vs Qlik Sense Sales Formula

Thu, 23 Jun 2016 22:15:41 GMT

Swuehl,

It was not returning any data. The issue was as you mentioned. Very well indeed. I was able to find that I had not used the same data parameter. All the other items you listed above were the same, but the aggregation wasn't correct because of my date field.

Thank you!