Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression for a complex report

Dear All,

Thanks for all your support and guidance.

I have a new issue.

Kindly refer to the attached file . There is a YDAR_YMAC.qvw in it.

I have a report that to be designed as per Budgeted vs Forecast.xlsx.

The report says that if we are checking out the results for say Jun2011,

then data from Jan to Jun should be from hq04(sales) one file,

the data for next two months i.e.Jul and Aug should come from Raw material fixed order(sales) file.

And the data for next three months i.e. Sep, Oct , Nov will come from Raw material Forecast (sales) other file.

What chart type should I use for this type of Report.

Please feel free to contact me if requirement is not clear.

I am new to Qlikview, and we are just using excel files other wise through Sql views I might have got th desired data.

Kindly help me out how the Expression can be made accordingly.

Is there any other way to create expressions in scripts as well.

Please help me out

1 Reply
Not applicable
Author

Please give your suggestions to help me out...........