topic Re: Total function functionality in linest m function in QlikView

Total function functionality in linest m function

Anonymous — Thu, 02 Jun 2016 15:13:11 GMT

Hi Team,

-->can we use variable in in total<> Expression

like :total<$(zCyclic1)>

-->if it is possible then how can i implement in my bellow logic

linest_m(total <$(zCyclic1)> aggr($(mtotalpeople),$(zCyclic1),[Date]),[Date]),

----here $(zCyclic1) contains india--

---$(zCyclic1) --it contains country's list --depend upon users selection country will be change

if the above implementation is not possible then could you please provide different code for same calculation of linest_m

Regards,

Bobby.

Re: Total function functionality in linest m function

swuehl — Thu, 02 Jun 2016 15:16:19 GMT

You should be able to use a field name list with the TOTAL qualifier, but not a field value list.

Re: Total function functionality in linest m function

Anonymous — Thu, 02 Jun 2016 15:24:50 GMT

Hay swuehl,

i agree that one

Old code is :

linest_m(total <india> aggr($(mtotalpeople),india,[Date]),[Date]),

but i need to implement like below:

linest_m(total <$(zCyclic1)> aggr($(mtotalpeople),$(zCyclic1),[Date]),[Date]),

is it possible?

not possible can we have any similar functions like above one?(Linest m)

Regards,

Bobby

Re: Total function functionality in linest m function

swuehl — Thu, 02 Jun 2016 15:28:53 GMT

In general, the dollar sign expansion is just a text replacement before the expression even gets evaluated.

So if the DSE is exactely just replaced with india, this should work well.

Re: Total function functionality in linest m function

Anonymous — Tue, 07 Jun 2016 12:13:25 GMT

Hi Swuehl,

i tired my self since last few days but til now i didn"t get any solution

please look the attached qvw file.

in that i mention my requirement as well as sample data

please look on that and

kind regards,

Bobby

Re: Total function functionality in linest m function

swuehl — Tue, 07 Jun 2016 12:35:38 GMT

Are you sure this is the right sample QVW?

I can't see any dimension groups in your application.

Re: Total function functionality in linest m function

Anonymous — Tue, 07 Jun 2016 12:50:14 GMT

Hi swuehl,

Sorry i attached wrong QVW file

could you please check attached QVW file now

Let me know if you need more information this

Regards,

Bob

Re: Total function functionality in linest m function

swuehl — Tue, 07 Jun 2016 13:20:43 GMT

You can use GetCurrentField( DimensionGroup ) to retrieve the current active field from your dimension group.

I created a variable to do this vDimGroup1.

Then replace your hard coded dimensions in the linest_m total and aggr() with that variable, as I've done for the first table.

Second table should be quite analogue.

Re: Total function functionality in linest m function

Anonymous — Wed, 08 Jun 2016 07:05:47 GMT

hi swuehl

For dimensionality level1 it"s working fine but when i was going to dimensionality level2,3 ...i was facing some issues on implementation of code in Expression tab(pivot properties-->expression tab)

and

below image please observe when actual results pivot is showing correct results but after adding cyclic group in pivot i was facing some data related issue

-->please compare cyclic group pivot and actual results pivot in attached QVW file

-->dimensionality level2,3 issues i mentioned in QVW file

let me know if you need more information on this

regards,

bob

Re: Total function functionality in linest m function

Anonymous — Wed, 08 Jun 2016 13:35:36 GMT

hi swuehl

please drop your response inline and if you need more information let me know

Kind Regards,

Bob

Re: Total function functionality in linest m function

Wed, 08 Jun 2016 15:36:32 GMT

hi swuehl,

I noticed some of your activity on community and wanted to get in touch about an opportunity.

Could you please shoot me an email if interested (yours is set to private, hence the thread hijacking)?

Thanks

Arun

Re: Total function functionality in linest m function

swuehl — Wed, 08 Jun 2016 18:36:53 GMT

There were a couple of small issues with your expressions:

a) Dimension groups not spelled correctly in variable definition.

b) wrong syntax using total qualifier with field list (only one total qualifier allowed in the aggregation function, comma separated field list in angle brackets)

c) missing commas

I am a little tired doing these corrections which I believe you can find yourself spending some more minutes.

For now, this is my last response to this thread.

Regards,

Stefan

Re: Total function functionality in linest m function

swuehl — Wed, 08 Jun 2016 18:39:06 GMT

Arun,

if you want to write me personal message, accept my follower request and follow me (click the follow button on my profile page). Then you should be able to send me a message.

Stefan