Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
brijesh1991
Partner - Specialist
Partner - Specialist

Refering Demension Value

Hi,

In dimension of chart I have field: City

I have one excel which have CityExcel field:

In Chart:

I had dimension: City

Expression: Sum({$<CityExcel={'Delhi'}>}Amount) where Delhi comes from Dimension "City" field

I want to write a generalize expression, so that {'Take value from dimension'}

Please put ideas

1 Reply
Gysbert_Wassenaar

If your City field is independent of your CityExcel field and you select only one value in City then this expression should do what you want: Sum({$<CityExcel={'$(=only(City))'}>}Amount)


talk is cheap, supply exceeds demand