topic Re: Set analysis won't calculates per dimension or per row..so what's the solution? in QlikView

Set analysis won't calculates per dimension or per row..so what's the solution?

gauthamchilled — Sat, 16 Nov 2024 03:15:39 GMT

Hi All,

I understand that Set analysis won't calculates per dimension or per row..so what's the solution? I need to calculate the following but it returns only when specific dimension is selected.

(sum(Total {$< [Year] =
, [Qtr/Yr] =
, [Month] =
, [Mth/Yr] = {">=$(=monthstart( vReportAsAt, -24 ))<=$(=monthstart( vReportAsAt, -13 ))"}
,Product=p({<Customer= {"$(=getfieldselections(Customer))"}>})
,Customer=
> }
[Customer Payment] ))

I would like to calculate the value per row so i have to remove this p({<Customer= {"$(=getfieldselections(Customer))"}>})

and come up with some alternative to calculate per value of dimension.

please help.

Gautham

Re: Set analysis won't calculates per dimension or per row..so what's the solution?

gauthamchilled — Wed, 19 Jun 2019 02:12:39 GMT

Any help would be appreciated..Thanks

Re: Set analysis won't calculates per dimension or per row..so what's the solution?

gauthamchilled — Wed, 19 Jun 2019 02:55:06 GMT

bump

Re: Set analysis won't calculates per dimension or per row..so what's the solution?

jonathandienst — Wed, 19 Jun 2019 05:24:48 GMT

I am not sure what you are wanting to do, or how you want o change it. Field selections are global and so are set expressions.

Re: Set analysis won't calculates per dimension or per row..so what's the solution?

gauthamchilled — Wed, 19 Jun 2019 06:42:55 GMT

Hi,

Eg:

Dimension: Insurer

Expression: (sum(Total {$< [Year] =
, [Qtr/Yr] =
, [Month] =
, [Mth/Yr] = {">=$(=monthstart( vReportAsAt, -24 ))<=$(=monthstart( vReportAsAt, -13 ))"}
,Product=p({<Insurer= {"$(=getfieldselections(Insurer))"}>})
,Insurer=
> }
[Premium] ))

Requirement: Total premium for the products per insurer(dimension value)

Product=p({<Insurer= {"$(=getfieldselections(Insurer))"}>}) --> To get same list of products owned by all other insurer . This expression works perfect if i select one insurer, if i remove the selection it is not. Because set analysis calculates per chart not per row.

Thanks,

Gautham

Re: Set analysis won't calculates per dimension or per row..so what's the solution?

tresB — Wed, 19 Jun 2019 06:49:11 GMT

Best way to get help in this would be sharing a sample app and explain the expected output there.

Re: Set analysis won't calculates per dimension or per row..so what's the solution?

gauthamchilled — Wed, 19 Jun 2019 07:15:07 GMT

Hi Tresesco & Jo,

Attached a sample document and requirement in screenshot.

Re: Set analysis won't calculates per dimension or per row..so what's the solution?

swuehl — Wed, 19 Jun 2019 07:23:29 GMT

I can't open your sample right now, but I think one issue might be the result of the Dollar sign Expansion.

What if you try

,Product=p({<Insurer= $::Insurer>})

or just

,Product=p()

instead?

Re: Set analysis won't calculates per dimension or per row..so what's the solution?

gauthamchilled — Wed, 19 Jun 2019 07:35:57 GMT

Hi Swuehi,

I attached a perosnal edition now

Re: Set analysis won't calculates per dimension or per row..so what's the solution?

tresB — Wed, 19 Jun 2019 07:53:36 GMT

May be this?

Sum(Aggr( sum(TOTAL <Product> Premium),Insurer, Product))

Re: Set analysis won't calculates per dimension or per row..so what's the solution?

gauthamchilled — Wed, 19 Jun 2019 10:26:27 GMT

Hi Tresesco,

Will your approach will work only if all the fields are from the same table?

Thanks,

Gautham

Re: Set analysis won't calculates per dimension or per row..so what's the solution?

gauthamchilled — Thu, 20 Jun 2019 05:37:40 GMT

@tresB Your solution works perfect until i calculate i use set analysis for current ,previous calc or if i have to ignore selection. I am in need of using incorporating this in set..

Could you please help?

Thanks,

Gautham

Re: Set analysis won't calculates per dimension or per row..so what's the solution?

tresB — Thu, 20 Jun 2019 07:51:42 GMT

I am bad in imagination, or may be just don't want to put extra effort in doing so. 😋 Request you to replicate your issue in a sample app, that would help me help you.