Qlik Community

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 
Search instead for 
Did you mean: 
Highlighted
Creator
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.

 

please help.

 

Gautham

Labels (2)
12 Replies
Highlighted
Creator
Creator

Hi Tresesco,

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

 

Thanks,

Gautham

Highlighted
Creator
Creator

@tresesco  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

Highlighted
MVP
MVP

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.