Refering Demension Value

brijesh1991 — Wed, 12 Nov 2014 10:05:16 GMT

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

Re: Refering Demension Value

Gysbert_Wassenaar — Wed, 12 Nov 2014 10:15:18 GMT

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)

topic Re: Refering Demension Value in QlikView

Refering Demension Value

Re: Refering Demension Value