Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
in script
LOAD employee,
sum([Sales Amount])
where wildmatch([_Active employee],'1')
group by employee
Regards
Hi,
like this,
SUM({<[_Active employee]={'1'}>}[Sales Amount])
Regards
Load
Employee, Sum (([Sales Amount]) as SalesAmount
resident myTable
where[_Active employee]=1)
Group by Employee
let me know
Hi,
in script
LOAD employee,
sum([Sales Amount])
where wildmatch([_Active employee],'1')
group by employee
Regards
Hi,
In the script you can use
if([_Active employee]=1,sum([Sales Amount])) as Sales_amount
as use Sales_amount Dimension.
sum({<Active employee='1'>} Sales)
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;
Thanks, that's perferct
Sorry but I think that the answer you marked as correct doesn't work because there isn't the source table in the query....
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;