Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Error in Expression!!

Hello,

I want sum Of Amount according to current selection of name . I have used following script but no chart is showing. Please help.Thanks

Sum({$<Name= {$}>}Amount)

3 Replies
jyothish8807
Master II
Master II

Hi,

Create a variable:

var=GetFieldSelections(Name)

in exp:

Sum({$<Name= {'$(=var)'}>}Amount)


Regards

KC

Best Regards,
KC
MarcoWedel

If you want to sum amount for the records associated to one of the selected names, then


Sum(Amount)


should be enough, because it's standard functionality of QlikView to only use selected (or possible) values.


hope this helps


regards


Marco

ashfaq_haseeb

Agree with Marco.

If you want script or formulae

Then try like this

Sum({$<Name= P(Name)>}Amount)

Regards

ASHFAQ