topic show if expression sum in text box in QlikView

show if expression sum in text box

Wed, 12 Feb 2014 17:03:58 GMT

Hello,

I have made an expression which gives me all sessionuserid where they only have 1 buy. I can make this in a straight table and then sum of total rows. Then i get row many SessionUserIDs who only bought once.

How do i show this in an textbox?

In picture you can see expression - Maybe it can be made otherwise?

Thanks

Re: show if expression sum in text box

Nicole-Smith — Wed, 12 Feb 2014 17:06:09 GMT

In texbox:

sum(aggr(YourExpression,YourFirstDimension,YourSecondDimension, etc.)

Re: show if expression sum in text box

MayilVahanan — Wed, 12 Feb 2014 17:17:53 GMT

Try like this

= Sum(Aggr(if(Count({<EventType={'Buy'}>}distinct SessionIDINT)=1, 1, 0), SessionUserID))