Sql query in script for qlikview

[#1]

Hello,

May I know to apply in script level?

SUM(AMT) for CATEGORY in ('123', '456', '789')

I want to apply in script not in chart .

Thanks.

[#2]

Hi Jagan,

I need to get the balance as new field.

I know can done it in set analysis way, but I need to be done in script level. Later I need to do some calculation using the new field.

Set analysis formula cannot apply in script level.