topic Re: Create If-else Calculation on Text Object in QlikView

Create If-else Calculation on Text Object

ksomosera10 — Fri, 11 Aug 2017 02:57:38 GMT

Hi,

I have this Text Object that contains formula of IF-ELSE and aggregating a certain fields.

I can't see any result, just a plain dash(-) on Text Object. Can you help me out here?

Thanks in advance!

Re: Create If-else Calculation on Text Object

prachisangewar — Fri, 11 Aug 2017 03:08:34 GMT

Hi Kevin,

Can you share your expression ?

Easier to advise .

Thanks.

Re: Create If-else Calculation on Text Object

ksomosera10 — Fri, 11 Aug 2017 03:11:02 GMT

Thanks!

Here it is:

=IF(Category = 'ADMIN', NUM(SUM(Hours))

Re: Create If-else Calculation on Text Object

prachisangewar — Fri, 11 Aug 2017 03:19:01 GMT

Try this

=if(Category = 'ADMIN',NUM(SUM(Hours),'#,##0'),0)

Re: Create If-else Calculation on Text Object

Muthu — Fri, 11 Aug 2017 05:06:39 GMT

Try this.

=sum({$<CATEGORY={ADMIN}>} HOURS)..

If the condition didnt satisfy it will automatically give 0, so there is no need of else condition here.

Re: Create If-else Calculation on Text Object

sasiparupudi1 — Fri, 11 Aug 2017 05:32:57 GMT

May be try

If (substringcount (GetFieldSelections (Category, ':'))>0,NUM(SUM(Hours),0)

Re: Create If-else Calculation on Text Object

Anonymous — Fri, 11 Aug 2017 06:36:07 GMT

Try this:

sum({<Category={'ADMIN'}>}Hours)

Re: Create If-else Calculation on Text Object

effinty2112 — Fri, 11 Aug 2017 07:52:28 GMT

Hi Kevin,

Rewrite it as

Sum(if(Category = 'ADMIN',Hours))

Sum the if, don't if the sum.

Muthu has already given you an expression that will work and if you're comfortable with set analysis expression use that one. If you have an expression containing an 'if' using a set analysis expression instead will be quicker and when you're used to the syntax will be easier to read.

Cheers

Andrew