topic Re: Count IF-Else statement in QlikView

Count IF-Else statement

awalhashim — Sat, 16 Nov 2024 05:13:52 GMT

Hi,

i have a straight table consist of SaleID, Interest.BU, Booking.BU. Since both BU from Interest and Booking is many-to-many relationship so i added an expression and come out with correct BU.

if(Interest.BU = Booking.BU,count(SaleID),0)

Now i want to count the SaleID and InterestID in which in another expression but seems to fail to get the correct no. it counting the whole id. i want the something like this.

Count(if Interest.BU = Booking.Bu)

which met the condition above.

Re: Count IF-Else statement

Thiago_Justen_ — Fri, 16 Nov 2018 01:35:09 GMT

You could try it out:

Count({<"Interest.BU"= {"=Booking.BU"}>}SaleID)

Or

Count(If(Interest.BU = Booking.BU,SaleID))

Cheers

Re: Count IF-Else statement

awalhashim — Fri, 16 Nov 2018 01:45:20 GMT

Hi Thiago thanks for replying.

It doesn't work. Still return 0 when its counting.

Re: Count IF-Else statement

Thiago_Justen_ — Fri, 16 Nov 2018 01:53:49 GMT

Could you please share a mockup?