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: 
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
avinashelite

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

Not applicable
Author

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


avinashelite

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
Champion III
Champion III

Try below

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Not applicable
Author

Thanks Vineeth, Your expression working for me

vinieme12
Champion III
Champion III

Glad to help,


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

Qlik Community Tip: Marking Replies as Correct or Helpful

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.