Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Sum({<Region={'East','South'}>}Amount)
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
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
Try below
=Sum({<Region*={'East','South'}>}Amount)
Thanks Vineeth, Your expression working for me
Glad to help,
pnreddy12, please close the thread my marking the response as correct
Qlik Community Tip: Marking Replies as Correct or Helpful