search

nodtvedt / qlik-sense-r-regression-extension

Simple proof of concept Qlik Sense Extension to connect a Qlik Sense hypercube to an Open CPU R web service.
MIT License
7 stars 8 forks source link

A more usable Sense Output #1

Closed cotiso closed 8 years ago

cotiso commented 8 years ago

Hi nodtvedt,

Great example ! Thank you for all the trouble.

In order to make this more useful in Sense interface, it would be cool to have the result in Sense displayed not as the regular text R is returning, but as a table with 5 columns:

Call Intercept mkt_tf smb hml Im(formula = ....) -0.0013338 -0.8139 0.5896 0.612605

(for your example)

nodtvedt commented 8 years ago

Thanks for the feedback.

Indeed, I agree it would be useful to provide a prettier formatting of the result set. It is not trivial to parse the text result from lm() and convert it to a table though, and my initial experiments leads me to believe I'd be better off if I write an R wrapper on the server that returns the result set as a JSON object rather than faffing about with string-parsing.

I'm unlikely to spend time on modifying this proof-of-concept, but I'd be happy to merge any contributed code you may have.

cotiso commented 8 years ago

Tx for the fast answer.

Not yet such an advanced R develeoper… I would rather try in Qlik some things…

In case we do something relevant, I will let you know.

Tx again for making the sample and sharing.

Sempre fi,

Cotiso

From: nodtvedt [mailto:notifications@github.com] Sent: Saturday, July 02, 2016 9:52 PM To: nodtvedt/qlik-sense-r-regression-extension qlik-sense-r-regression-extension@noreply.github.com Cc: cotiso cotiso.hanganu@qqinfo.ro; Author author@noreply.github.com Subject: Re: [nodtvedt/qlik-sense-r-regression-extension] A more usable Sense Output (#1)

Thanks for the feedback.

Indeed, I agree it would be useful to provide a prettier formatting of the result set. It is not trivial to parse the text result from lm() and convert it to a table though, and my initial experiments leads me to believe I'd be better off if I write an R wrapper on the server that returns the result set as a JSON object rather than faffing about with string-parsing.

I'm unlikely to spend time on modifying this proof-of-concept, but I'd be happy to merge any contributed code you may have.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/nodtvedt/qlik-sense-r-regression-extension/issues/1#issuecomment-230116557 , or mute the thread https://github.com/notifications/unsubscribe/AI4IIv5GYo_-7buNECz1AZHEBkmZcP_fks5qRrNPgaJpZM4JDTzp .