topic Need Urgent Reply in QlikView

Need Urgent Reply

Fri, 19 Jun 2009 18:16:01 GMT

I have following questions and need somee answers very urgently.

Q1:)As we can move data in Excel sheet from the QlikView Sheet object,how can or is it possible to move data from QlikView sheet object in Matlab,minitab or SPSS.?

Q2:)Can we use Statistical Fuctions in QlikView as it is used in Matlab,minitab or SPSS.?If yes then how.Please give me the detail information about those functions?

Q3:)If we cannot use Statistical Fuctions in Qlikview ,is their any other possible way we can use them in QlikView?

Q4:)Can QlikView specially develope a plug-in to connect or to transfer data into Matlab,minitab or SPSS as per client request?

Regards

Sikandar.

Need Urgent Reply

Fri, 19 Jun 2009 18:23:10 GMT

Hi Sikandar,

answer for Q2: Yes QV has statistical functions on board.

Se QV Help.

Rainer

Need Urgent Reply

mantaq10 — Sun, 22 Aug 2010 23:30:46 GMT

Hi Sikandar,

This is a veeeery late response but I guess its an important question for all of us to document.

Q1) you can do this by using the Store command
Store <tablename> into filename.txt (txt) for a csv file which can then be imported in the said tools.

q2)We have the base of most statistical functions implemented in QLikview, namely:

1. rand() and P.D.F (normdist, norminv, finv, fdist, tdist, tinv, etc)
These two functions can be used to program monte carlos, markov models, clustering using nearest neighbours and variants, and other activities.

2. Univariate Linear Regression (linest_* functions):
These are used for linear regression and there are algorithms for multiple linear regression from univariate linear regression (see regression orthogonalization).

Q3) question not clear to me

Q4) Not per my knowledge. to import data from SPSS, I think one can write a custom connector for ARFF files but im not sure about SAV files as they are SPSS proprietary.

Need Urgent Reply

pablolabbe — Thu, 20 Jan 2011 23:50:43 GMT

Do you have some demo application showing how to apply these functions ?

Need Urgent Reply

johnw — Fri, 21 Jan 2011 00:08:42 GMT


Pablo Labbe Ibaceta wrote:Do you have some demo application showing how to apply these functions ?

Depends on what you're looking for. In the attached example, I use linest_b and linest_m to create a forcast for future months based on the linear trend of the months of data we do have. I also calculate the correlation coefficient for this line as a way of indicating how "trustworthy" the forecast might be. So, three of the many available statistical functions.

Need Urgent Reply

pablolabbe — Fri, 21 Jan 2011 03:17:16 GMT

Very Very Thank you John, you are the Guru of this community, always with an enlightening answer.

Now I understood the sintaxis and how to use these functions in conjunction with AGGR .

Cheers,

Pablo Labbe

Need Urgent Reply

Thu, 02 Jun 2011 14:14:16 GMT

Atif Abdul-Rahman wrote:
2. Univariate Linear Regression (linest_* functions):
These are used for linear regression and there are algorithms for multiple linear regression from univariate linear regression (see regression orthogonalization).

Atif, could you please provide an example of how to make a multiple linear regression from univariate one in QlikView?

Maybe someone else knows how to do that?

Thank you