Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Hi,
Create a variable:
var=GetFieldSelections(Name)
in exp:
Sum({$<Name= {'$(=var)'}>}Amount)
Regards
KC
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
Agree with Marco.
If you want script or formulae
Then try like this
Sum({$<Name= P(Name)>}Amount)
Regards
ASHFAQ