topic Re: Help needed on set analysis in QlikView

Help needed on set analysis

Wed, 17 Jun 2015 09:40:39 GMT

Hi Team,

I need your Precious help on set analysys.

I have two fields called [emp year of hire] and [emp name].

Now i have towrite a set expression to show the sum(sal) for employees whose year of hire is 2010 to 2015 and also have to include sal of employees if anybody having null value as [emp year of hire].

Thanks in advance.

Best Regards,

Nani.

Re: Help needed on set analysis

avinashelite — Wed, 17 Jun 2015 09:46:42 GMT

try like this:

if( ([emp year of hire]>=2010 and [emp year of hire]<=2015) or [emp year of hire]=null(),sum(sal))

sum({<[emp year of hire]={">='2010'<='2015'"}>}sal)

Re: Help needed on set analysis

PrashantSangle — Wed, 17 Jun 2015 09:47:28 GMT

Hi,

Try this,

sum({<[emp year of hire]={">=2010<=2015"},[emp year of hire]={"=ISNULL([emp year of hire])"}>}Sal)

Regards

Re: Help needed on set analysis

Wed, 17 Jun 2015 10:07:33 GMT

Hi avinash,

Thanks for your reply.

My requirement is to incorporate null value condition in set expression.

tried ur expression but it is giving results for only given years not for null values.

Regards,

Nani

Re: Help needed on set analysis

Wed, 17 Jun 2015 10:08:51 GMT

Hi Max,

Thanks for your reply...

The expression that u mentioned is returning ' 0' as a result.

Regards,

Nani.

Re: Help needed on set analysis

PrashantSangle — Wed, 17 Jun 2015 10:14:51 GMT

Hi,

Try

Simple if else

try like

sum(if((isnull([emp year of hire]) or len(trim([emp year of hire]))=0) or ([emp year of hire]>=2010 AND [emp year of hire]<=2015),Sal))

Note: Check Bracket if any missing

Regards

Re: Help needed on set analysis

stigchel — Wed, 17 Jun 2015 10:15:39 GMT

Can you try with

Sum({1-< [emp year of hire]={"<2010"} >} Sal)

Re: Help needed on set analysis

Wed, 17 Jun 2015 10:23:11 GMT

Try this,

sum({<[emp year of hire]={">='2010'<='2015'"}>}sal) + Sum(If(IsNull([emp year of hire]),sal,0))

Re: Help needed on set analysis

Kushal_Chawda — Wed, 17 Jun 2015 11:09:00 GMT

Try like this

sum({<[emp year of hire]={">=2010<=2015"}>} if(ISNULL([emp year of hire]),Sal,Sal))