Scripting

[#1]

Hi

I'm pretty new to QV, need help with this statement.

I need Sum of Sales Amount only for Active employees.

Please could you send me the correct script

Sum (([Sales Amount]),where[_Active employee]=1)

Thanks

Chris

[PrashantSangle]

Hi,

like this,

SUM({<[_Active employee]={'1'}>}[Sales Amount])

Regards

[alexandros17]

Load

Employee, Sum (([Sales Amount]) as SalesAmount

resident myTable

where[_Active employee]=1)

Group by Employee

let me know

[PrashantSangle · Accepted solution]

Hi,

in script

LOAD employee,

      sum([Sales Amount])

where wildmatch([_Active employee],'1')

group by employee

Regards

[#5]

Hi,

In the script you can use

if([_Active employee]=1,sum([Sales Amount])) as Sales_amount

as use Sales_amount Dimension.

[ashwanin]

sum({<Active employee='1'>} Sales)

[qlikviewwizard]

Hi Chris,

Please try this.

Hope this will Helpful to you.

Data:

LOAD employee,

      sum([Sales Amount])

where wildmatch([_Active employee],'1')

group by employee;

[#8]

Thanks, that's perferct

[alexandros17]

Sorry but I think that the answer you marked as correct doesn't work because there isn't the source table in the query....

[qlikviewwizard]

Hi,

Script is something like this.

Data:

LOAD employee,

      sum([Sales Amount])

      FROM

[QVD\Sales.qvd]

(qvd)

where wildmatch([_Active employee],'1')

group by employee;