topic Re: Condition in QlikView

Condition

master_student — Fri, 24 Feb 2017 08:34:14 GMT

hello

I need to implement this condition :=if (sum(ARPU)=0, count(DN_NUM))

but the result is nothing :

Thanks

Re: Condition

rahulpawarb — Fri, 24 Feb 2017 08:53:19 GMT

Hello Wiem,

I hope that you are doing good!

As per my understanding, the expression you have used has Sum(ARPU) value greater than 0. Due to this it is showing no value (else part of if statement). You can validate it by revamping your expression as below:

=if (Sum(ARPU)=0, Count(DN_NUM), 'Sum(ARPU) is non zero')

Hope this will be helpful.

Regards!

Rahul

Re: Condition

jonathandienst — Fri, 24 Feb 2017 08:57:14 GMT

Er, with that information, you want us to help exactly how? I have misplaced my magic wand.

Re: Condition

master_student — Fri, 24 Feb 2017 09:03:17 GMT

The expression is ok but i didn't get nothing as a result, i just need to know the reason :

i need to know the number of dn_num that have a null arpu

Re: Condition

tresB — Fri, 24 Feb 2017 09:11:18 GMT

May be like:

Count(Distinct {<DN_NUM={"=len(trim(APRU))=0"}>}DN_NUM)

Re: Condition

rahulpawarb — Fri, 24 Feb 2017 09:53:13 GMT

Hello Wiem,

You can also refer below given expression:

Sum(If(Len(APRU) = 0, 1))

Regards!

Rahul

Re: Condition

Anonymous — Fri, 24 Feb 2017 13:24:27 GMT

You are looking for a 'WHERE CLAUSE' and not an IF Statement.

Its should look like this: COUNT( {<SUM(ARPU) = {'0'}>} DN_NUM)