New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for
Did you mean:
Highlighted
Creator

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

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.

Gautham

Labels (2)

• Set Analysis

1 Solution

Accepted Solutions
Highlighted
MVP

May be this?

12 Replies
Highlighted
Creator

Any help would be appreciated..Thanks

Highlighted
Creator

bump

Highlighted

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Creator

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=
> }

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

Highlighted
MVP

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

Highlighted
Creator

Hi Tresesco & Jo,

Attached a sample document and requirement in screenshot.

Highlighted
MVP

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()

Highlighted
Creator

Hi Swuehi,

I attached a perosnal edition now

Highlighted
MVP

May be this?