Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

GROUP BY

How can i make group by on the sales?

I want to compare total sales by month-

to compare the total sales  of january to the total forecast of january etc.

3 Replies
MVP
MVP

Re: GROUP BY

Don't know what you really want. Please check attached file...

Not applicable

Re: GROUP BY

I want to write a script (in the edit scrupt) that will bring the total actual sales of each month versus a forecast of sales each month.

The Field sales in the forecast table is"Forecast_Amount".

The Field sales in the table Sales_Actual is "Amount".

Re: Re: GROUP BY

Alon

Manish got there first, my qvw is very similar his.

It is shame that their are no common dimensions for the 2 tables to give some slicing & dicing, but unfortunately that is oft the case with real data from the real world.

Best Regards,     Bill

Community Browser