topic Re: Set Analysis in Calculation (Multiplication) in QlikView

Set Analysis in Calculation (Multiplication)

Tue, 06 Oct 2015 13:32:02 GMT

Hi,

I have a (for me) very tough Topic.

I want to calculate something but I dont get it to work. Maybe someone of you can help me

Now the Formular:

=TaxRate*[Act Year IFRSADJ]
(The Calculation works but it calculate all entries, - even the ones with DefTaxCode = 'N/A')

Wish:

=TaxRate*[Act Year IFRSADJ] (ONLY If DefTaxCode <> 'N/A')

Thanks in advance.

Chris

Re: Set Analysis in Calculation (Multiplication)

sinanozdemir — Tue, 06 Oct 2015 13:47:54 GMT

Hi Christian,

Can you try the below?

Only({<DefTaxCode = {"<>N/A"}>} TaxRate) * [Act Year IFRSADJ]

Hope this helps.

Re: Set Analysis in Calculation (Multiplication)

Kushal_Chawda — Tue, 06 Oct 2015 13:54:03 GMT

try

sum({<DefTaxCode -= {'N/A'}>}TaxRate* [Act Year IFRSADJ])

only({<DefTaxCode -= {'N/A'}>}TaxRate* [Act Year IFRSADJ])

Re: Set Analysis in Calculation (Multiplication)

Tue, 06 Oct 2015 14:26:44 GMT

Hi Sinan,

unfortunately it did not work.

But I now realised, that the Problem of the Formular is [Act Year IFRSADJ]

I dont know why, but Qlikview does not calculate with a field (that is already calculated)

Maybe you have another idea 🙂

Chris

Re: Set Analysis in Calculation (Multiplication)

Tue, 06 Oct 2015 14:27:12 GMT

Hi Christian!

Just wanted to share a tool with you that has saved my life many times.

Qlik Set Analysis Wizard.

http://tools.qlikblog.at/SetAnalysisWizard/QlikView-SetAnalysis_Wizard_and_Generator.aspx?sa=

Hopefully it helps!

Will

Re: Set Analysis in Calculation (Multiplication)

sinanozdemir — Tue, 06 Oct 2015 14:33:08 GMT

Can you post a sample data-set?

Re: Set Analysis in Calculation (Multiplication)

avinashelite — Tue, 06 Oct 2015 14:35:20 GMT

try like this:

if (DefTaxCode<>'N/A',TaxRate*[Act Year IFRSADJ])

Re: Set Analysis in Calculation (Multiplication)

Wed, 07 Oct 2015 14:29:58 GMT

I just get Zeros. Unfortunately it does not work.

Re: Set Analysis in Calculation (Multiplication)

Wed, 07 Oct 2015 14:36:23 GMT

Hi Avinash R,

I tried your idea and it worked partially.

As you can see, the second column is calculated.

Challenge Here:

Line 416 does not calculate --> that is correct

BUT: Line 417 did calculate the sum (it should be Zero as well)

I tried some things but nothing worked.

When everything works, Line 418 should Show the value -696.542,39 (That is my wish 😉

Here my calculation:

if(DefTaxCode <> 'N/A',-Unternehmenssteuersatz*[Akt. Jahr IFRSADJ],0)

Does somebody have an idea?

Thanks in advance

Chris

Re: Set Analysis in Calculation (Multiplication)

sinanozdemir — Wed, 07 Oct 2015 14:45:24 GMT

Is [Akt. Jahr IFRSADJ] field a dimension or an expression?

Re: Set Analysis in Calculation (Multiplication)

nagaiank — Wed, 07 Oct 2015 14:54:23 GMT

Did you try the following:

If(DefTaxCode <> 'N/A',TaxRate*[Act Year IFRSADJ])

Re: Set Analysis in Calculation (Multiplication)

avinashelite — Thu, 08 Oct 2015 04:53:10 GMT

Hi Christian,

Can you please share your app ??