topic Re: set anylsis question in QlikView

set anylsis question

Fri, 02 Mar 2012 07:38:36 GMT

Hi all.

have a table having employee_no and bill

actualy SUP-GK-452 and SUP-GK-333 are code for retired employees.

I want to show the sum in graph only those employee who are not like 'SUP%' in one graph and

only for those who are like 'SUP%; in another graph.

how can i do this through setanylsis.??

CELAMBARASAN — Fri, 02 Mar 2012 07:42:44 GMT

Hi,

Try with this expression

Sum({<employee_no-={'SUP*'}>} bill) for not 'Sup%'

Sum({<employee_no={'SUP*'}>} bill) for 'SUP%'

Hope it helps

Celambarasan

v_iyyappan — Fri, 02 Mar 2012 07:51:28 GMT

Hi,

Use the expression like,

not like 'SUP%' = if(left(employeeno,3) <> 'SUP',Sum(bill))

like 'SUP%' = if(left(employeeno,3) = 'SUP',Sum(bill))

Regards,

Iyyappan

jagan — Fri, 02 Mar 2012 07:59:53 GMT

Hi,

Try this

not 'Sup%' =Sum({<employee_no-={'SUP*'}>} bill)

'SUP%'=Sum({<employee_no={'SUP*'}>} bill)

Hope it helps you.

Regards,

Jagan.

Fri, 02 Mar 2012 08:10:02 GMT

hi...

you can use

"=Sum({1<Emp_NO={"SUP*"}> }Bill)" for SUP*

and

=Sum({1-$<Emp_NO ={"SUP*"}> }Bill)

for other

Thanks and regards

Arun Goel

Tue, 19 Jun 2012 06:02:17 GMT

thnks sir..

its really works