topic Re: Scripting in QlikView

Scripting

Mon, 07 Sep 2015 07:08:17 GMT

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

Re: Scripting

PrashantSangle — Mon, 07 Sep 2015 07:12:33 GMT

Hi,

like this,

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

Regards

Re: Scripting

alexandros17 — Mon, 07 Sep 2015 07:12:42 GMT

Load

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

resident myTable

where[_Active employee]=1)

Group by Employee

let me know

Re: Scripting

PrashantSangle — Mon, 07 Sep 2015 07:15:53 GMT

Hi,

in script

LOAD employee,

sum([Sales Amount])

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

group by employee

Regards

Re: Scripting

Mon, 07 Sep 2015 07:16:10 GMT

Hi,

In the script you can use

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

as use Sales_amount Dimension.

Re: Scripting

ashwanin — Mon, 07 Sep 2015 07:18:59 GMT

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

Re: Scripting

qlikviewwizard — Mon, 07 Sep 2015 07:21:45 GMT

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;

Re: Scripting

Mon, 07 Sep 2015 07:23:38 GMT

Thanks, that's perferct

Re: Scripting

alexandros17 — Mon, 07 Sep 2015 07:27:30 GMT

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

Re: Scripting

qlikviewwizard — Mon, 07 Sep 2015 07:40:27 GMT

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;

Re: Scripting

PrashantSangle — Mon, 07 Sep 2015 07:51:06 GMT

hehee,

You are correct, I missed TableName line in my solution

Regards