topic Re: Use our own Formula on Qlikview?? in QlikView

Use our own Formula on Qlikview??

Fri, 04 Jul 2014 00:56:52 GMT

i would like to ask izzit possible for us to put our own formula into Qlikview and then to get 1 curve on our scatter chart?? it is possible we create our own formula on expressions' definition part and then to generate our own graph??

Re: Use our own Formula on Qlikview??

nilo_pontes — Fri, 04 Jul 2014 03:32:25 GMT

Hi Christopher,

You can generate your own data inside QlikView's model, yes.
Once you loaded your data to the application, you can calculate it by many ways using the predefined formulas or creating your own.
QlikView has 11 types of graphs + variations.

Hope that helps you, and if it does, please mark the answer as 'helpful' or 'right'.

Best Regards,

Nilo

Re: Use our own Formula on Qlikview??

Fri, 04 Jul 2014 03:36:59 GMT

Hi Nilo,

i want to ask if i already hv my scatter chart, and then nw i hv a formula with y = ab+cd+ed+df / (ad+cc)(ab+cd) like this and use this formula to get a line on my scatter chart....izzit possible to do it?if i want to do it then hw should i do?generate my own formula on expressions' definition??

Re: Re: Use our own Formula on Qlikview??

nilo_pontes — Fri, 04 Jul 2014 13:52:30 GMT

Christopher,

Please, take a look at the attached file.

Maybe it helps you to answer your question.

Regards

Re: Re: Use our own Formula on Qlikview??

Mon, 07 Jul 2014 00:45:30 GMT

Nilo,

i would not able to open the file bcoz my Qlikview is only able to open the file which is create by my own computer only. So may u write down how to write my own formula into qlikview and use it? i need how to do only can insert my own formular? like nw i only need to insert a line which is depand on Output=w+(y^2)(I). so i need hw to do only can get this line on my scatter chart?