topic Error in Expression!! in QlikView

Error in Expression!!

Sun, 05 Oct 2014 10:15:03 GMT

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)

jyothish8807 — Sun, 05 Oct 2014 10:25:41 GMT

Hi,

Create a variable:

var=GetFieldSelections(Name)

in exp:

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

Regards

MarcoWedel — Sun, 05 Oct 2014 10:44:32 GMT

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 — Sun, 05 Oct 2014 13:38:03 GMT

Agree with Marco.

If you want script or formulae

Then try like this

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

Regards

ASHFAQ