topic Re: Can we use If and sum statment in same expression in QlikView

Can we use If and sum statment in same expression

Karim_Khan — Thu, 03 Sep 2015 15:11:00 GMT

Hi Team,

Can we use If and sum statment in same expression.I am trying to calculate the belwo expression into single statment but unable to achive the same.

Dimenssion:

=if([Entry Pages] <>'adsk:en:home' and [Entry Pages] <>'adsk:en_gb:404',[Entry Pages],Null())

Expression:

=sum(Visits)

If I will use only =sum(Visits) then it will give me the sum of value along with Junk character.

But I don't want Junk character in my calculation so I used the belwo set analysis in dimenssion

=if([Entry Pages] <>'adsk:en:home' and [Entry Pages] <>'adsk:en_gb:404',[Entry Pages],Null())

But I want to handle the both set analysis calculation in single expression.

Regards,

MRKachhiaIMP‌jagan‌gwassenaar‌Kush141087‌

Re: Can we use If and sum statment in same expression

Anonymous — Thu, 03 Sep 2015 15:13:19 GMT

try this Expression

=sum({<([Entry Pages]-={'adsk:en:home','adsk:en_gb:404'}>}Visits)

Re: Can we use If and sum statment in same expression

alexandros17 — Thu, 03 Sep 2015 15:14:12 GMT

The logig shoul be something like:

Sum(If(cond=true, MyField, 0))

Re: Can we use If and sum statment in same expression

cspencer3 — Thu, 03 Sep 2015 15:14:55 GMT

you should just be able to do:

Sum(

if([Entry Pages] <>'adsk:en:home' and [Entry Pages] <>'adsk:en_gb:404',[Entry Pages] )

)

Also, this is not set analysis. Just IF logic.

Re: Can we use If and sum statment in same expression

jagan — Thu, 03 Sep 2015 15:25:01 GMT

Hi,

Try like this

=Count({<[Entry Pages] -= {'adsk:en:home', 'adsk:en_gb:404'}>} Distinct Visits)

Hope this helps you.

Regards,

Jagan.

Re: Can we use If and sum statment in same expression

Karim_Khan — Thu, 03 Sep 2015 15:37:07 GMT

Tnx a lot

Re: Can we use If and sum statment in same expression

Karim_Khan — Thu, 03 Sep 2015 15:37:21 GMT

Tnx a lot