topic Re: Adding Commentary to a Report in QlikView

Adding Commentary to a Report

Fri, 21 May 2010 03:14:45 GMT

Hi All,

Seems like i'm the unlucky one pushing the formatted financials to you all, all the time. As you are all completing awesome sales apps with flexible data analysis, set analysis, graphs, gauges and animations, i'm trying to complete business objects style formatted general ledger reports (Qlikview's relative weakness). Do I have your empathy sympathy? good.

I would appreciate your help on this one 🙂

I need to produce commentary, linked to a line in a report, and i need it to be stored historically.

See a sample below:

Category			Actuals	Budget	Variance	% Variance	Budget	Note

Department
		Exploration and development				0%
		Consultancy	16	30	14	45%	385	1
		Freight				0%
		Legal Fees	-8	30	38	125%	355	2
		Statutory	25	19	-6	-31%	264	3
		Repairs and Maintenance				0%
		Office costs				0%
		Other office costs	0	2	1	75%	18
		Directors Fees	15	20	5	24%	240
		Payroll Cost	98	93	-5	-6%	1,116
		IT	1	5	3	70%	54
		Other Staff Cost	-0	14	14	100%	21
		Entertainment	1	3	2	80%	41
		Insurance	6	137	131	95%	172
		Training		2	2	100%	10
		Travel	-26	18	44	246%	242
		Marketing	11		-11	0%
		Motor Vehicle				0%
		SHEC				0%
	TOTAL ORDINARY EXPENSES		141	372	231	62%	2,918


Notes
1. YTD $856k consultancy fees includes expenditure of $500k for Consultancy in relation to CC.
2. MTD negative $8k Legal fees is a reversal of an over accrual in February 10.
3. MTD $25k Statutory fees were higher than forecast due to a $13k payment for listings fees, and a $12k payment to Security Transfers Registrars P/L for share maintenance fees.

For the solution, I've thought of using an input field

i.e.

INPUTFIELD Note,NoteText;

LOAD Department,

DepartmentMonthYear,

' ' as Note,

' ' as NoteText

RESIDENT DepartmentListing;

The DepartmentMonthYear would be linked to the Date Calendar. The Department would be linked to the GLMaster. I'd display the Note field on the RHS of the report table, while the Note AND NoteText field would be displayed at the bottom as a table box.

Is there a better way of doing this, or does this sound reasonable?

Adding Commentary to a Report

Fri, 21 May 2010 03:20:20 GMT

Note: I'd have to map the Header department details into the transactional table and join on Department AND MonthYear as a key.

Joining to the Date Calendar and the Master would create a loop.

Qlikview didn't link the linkage to start with. But creating a distinct link island seems to got around this issue. I'm now having an issue with being able to input text into a straight table.

Like John experienced here (http://community.qlik.com/forums/p/23612/90555.aspx#90555 ).

Re: Adding Commentary to a Report

Fri, 07 Feb 2014 21:34:11 GMT

Hello,

I notice this post if from a few years back. Did this solution work for you? Or what have you found successful?

We are looking at the notes functionality in v11.

Thanks!

Kevin

Re: Adding Commentary to a Report

Mon, 10 Feb 2014 04:24:40 GMT

Hi Kevin,

My first post for years

SImple answer - No. We never got a robust solution up and running. We tried using input fields which would store to QVD and re-read but this proved too flaky.

A foreign data source is needed with a unique key. Simple to implement but the additional data source is rarely more elegant than a spreadsheet.

Re: Adding Commentary to a Report

piekepotloed — Thu, 31 Jul 2014 10:02:46 GMT

Hi Kevin,

Did the notes functionality bring the solution or ...

Regards,

Peter