topic Re: Logic issue in QlikView

Logic issue

Fri, 09 Jan 2015 07:16:37 GMT

Hi all ,

In the below customized report my expression showing wrong results.can any one help me on this

my exp: if(ELECTRICITY_DUTY=0,Count(distinct CONNECTION_NO))

what to do if I want to get only Electricity duty Not counted accounts with 0 symbol, Expression showing all accounts.

Re: Logic issue

tresB — Fri, 09 Jan 2015 07:20:22 GMT

Try like:

Count(distinct If(ELECTRICITY_DUTY<>0, CONNECTION_NO))

Re: Logic issue

SunilChauhan — Fri, 09 Jan 2015 07:24:16 GMT

Count(distinct {<ELECTRICITY_DUTY-=0>}, CONNECTION_NO))

Re: Logic issue

Fri, 09 Jan 2015 07:27:53 GMT

Hi,

It is working fine ,but what to do if I want to show my result as 0 .Now it is showing as 1. My actual intention is to show them not to count.

Thanks,

Re: Logic issue

tresB — Fri, 09 Jan 2015 07:30:25 GMT

Try '=' instead of '<>'

Re: Logic issue

Anonymous — Fri, 09 Jan 2015 07:40:24 GMT

Hi,

Try in expression:

Count( {<ELECTRICITY_DUTY-=0>}, distinct CONNECTION_NO)

In Script:

Load *,
if(len(Trim(ELECTRICITY_DUTY))= 0,0,1) as ELECTRICITYCOUNT
Resident table
group by CONNECTION_NO;

In Expression:

Count( {< ELECTRICITYCOUNT = 1>}, CONNECTION_NO))

Regards

Neetha

Re: Logic issue

Fri, 09 Jan 2015 07:50:28 GMT

Thank you Neetha.

Re: Logic issue

preminqlik — Fri, 09 Jan 2015 07:50:42 GMT

hi there,

May be in set analysis like this :

Count({<CONNECTION_NO={'=ELECTRICITY_DUTY<>0'}>} distinct CONNECTION_NO)

Re: Logic issue

Fri, 09 Jan 2015 07:53:54 GMT

'=' is the correct answer..Thank you.

Re: Logic issue

Fri, 09 Jan 2015 07:56:43 GMT

Your exp :Count( {<ELECTRICITY_DUTY-=0>}, distinct CONNECTION_NO) showing error some where.

Re: Logic issue

Anonymous — Fri, 09 Jan 2015 08:12:03 GMT

Try:

Count( {<ELECTRICITY_DUTY-= {0}>} distinct CONNECTION_NO)