Add calculated dimension

[davyqliks]

HI Qlikers

I would appreciate some assistance please.

I am trying to add a calculated dimension so that the results of the dimension are filtered by location UK

So, i am adding the Dimension UK but i would like to filter these resluts by Another dimension ERP Location and the Value UK.

the closest i get to something like the required is

({$<[ERP LOCATION]= {'*UK*'}>} [Customer Name])

should i be using AGGR?

I would like to add a calculated dimension for [CUSTOMER NAME] so that only results from the dimension [ERP LOCATION]=UK show

If anybody could help i can apply this throughout my doc.

Thank you in advance.

[davyqliks]

the calculated dimension i am adding is to filter all results from a table which shows many expressions for sales calculations.

I am hoping the calculated dimension will in turn filter the results of the other expressions

Rank(Sum({1<[Inv Month]={Nov}, [Customer Name] -= {'***Customer name*****''}>}[Invoice Total]),1,1

concat(distinct [Brand Name] & [Retailer Name],', ')

sum({1<[MonthYear]={'Apr-2017'}>}[Invoice Total])

sum({1<[MonthYear]={'May-2016'}>}[Invoice Total])

sum({1<[MonthYear]={'May-2017'}>}[Invoice Total])

sum({1<[MonthYear]={'Jun-2016'}>}[Invoice Total])

=sum({1 <MonthYear={">=Jan-2016<=Jun-2016"}>} [Invoice Total])

=sum({1 <MonthYear={">=Jan-2017<Jun-2017"}>} [Invoice Total])

Will the calculated dimension have the effect i am looking for. I have not used these as of yet?

Thank you

[vinieme12]

Try calculated dimension as

AGGR( only({$<[ERP LOCATION]={'HK/UK'} >} [CUSTOMER NAME]) ,  [CUSTOMER NAME] )

or Add the SET ANALYSIS part to all expressions that you have in the chart'

this part

{$<[ERP LOCATION]={'HK/UK'} >}

[davyqliks]

Rather than a calculated dimension should i be adding the Location UK syntax to the existing Expressions?

Thank you in advance.

[vinieme12]

Yes, that would be the best option

[davyqliks]

Thank you Vineeth Pujari

I Will work on this option then.

Thank you all for the assistance