Qlik Community

Qlik GeoAnalytics Discussions

Discussion Board for collaboration regarding Qlik GeoAnalytics.

Not applicable

calculation in Text box

Hi All,

I have a Region Dimension that values are East,Northeast,Northwest,South and also have a measure 'Amount' , I have to create expression sum of amount for East, South even user selected Region dimension all values

Thanks in advance

6 Replies

Re: calculation in Text box

Sum({<Region={'East','South'}>}Amount)

Not applicable

Re: calculation in Text box

Thanks for reply,

if user selects East in regions filter The text box  has to calculate by East

if user selects East,Northeast,Northwest  in regions filter The text box  has to calculate by East


if user selects East,Northeast,Northwest,South in regions filter The text box  has to calculate by East,South


Re: calculation in Text box

Sum(Amount) this expression will give the results according to your selection

e.g if you select east this expression will give results for East ..similary if you select East ,South then it give results for East and South...


in your case

I could see you have lot for conditions ...may be

if(getfiledselections(Region)='East' or getfiledselections(Region)='Northeast' or getfiledselections(Region)='Northwest',

sum({<Region={'East'}>}Amount)

)


similar you could add the conditions 

vinieme12
Esteemed Contributor II

Re: calculation in Text box

Try below

=Sum({<Region*={'East','South'}>}Amount)

Not applicable

Re: calculation in Text box

Thanks Vineeth, Your expression working for me

vinieme12
Esteemed Contributor II

Re: calculation in Text box

Glad to help,


pnreddy12, please close the thread my marking the response as correct

Qlik Community Tip: Marking Replies as Correct or Helpful

Community Browser