
Re: Set Analysis in Calculation (Multiplication)
Sinan Ozdemir Oct 6, 2015 9:47 AM (in response to Christian Wylezol)Hi Christian,
Can you try the below?
Only({<DefTaxCode = {"<>N/A"}>} TaxRate) * [Act Year IFRSADJ]
Hope this helps.

Re: Set Analysis in Calculation (Multiplication)
Christian Wylezol Oct 6, 2015 10:26 AM (in response to Sinan Ozdemir)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)
Sinan Ozdemir Oct 6, 2015 10:33 AM (in response to Christian Wylezol)Can you post a sample dataset?

Re: Set Analysis in Calculation (Multiplication)
Avinash R Oct 6, 2015 10:35 AM (in response to Christian Wylezol)try like this:
if (DefTaxCode<>'N/A',TaxRate*[Act Year IFRSADJ])

Re: Set Analysis in Calculation (Multiplication)
Christian Wylezol Oct 7, 2015 10:36 AM (in response to Avinash R )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)
Sinan Ozdemir Oct 7, 2015 10:45 AM (in response to Christian Wylezol)Is [Akt. Jahr IFRSADJ] field a dimension or an expression?

Re: Set Analysis in Calculation (Multiplication)
Avinash R Oct 8, 2015 12:53 AM (in response to Christian Wylezol)Hi Christian,
Can you please share your app ??





Re: Set Analysis in Calculation (Multiplication)
kushal chawda Oct 6, 2015 9:54 AM (in response to Christian Wylezol)try
sum({<DefTaxCode = {'N/A'}>}TaxRate* [Act Year IFRSADJ])
or
only({<DefTaxCode = {'N/A'}>}TaxRate* [Act Year IFRSADJ])

Re: Set Analysis in Calculation (Multiplication)
Christian Wylezol Oct 7, 2015 10:29 AM (in response to kushal chawda )I just get Zeros. Unfortunately it does not work.


Re: Set Analysis in Calculation (Multiplication)
William Davidson Oct 6, 2015 10:27 AM (in response to Christian Wylezol)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/QlikViewSetAnalysis_Wizard_and_Generator.aspx?sa=
Hopefully it helps!
Will

Re: Set Analysis in Calculation (Multiplication)
Nagaian Krishnamoorthy Oct 7, 2015 10:54 AM (in response to Christian Wylezol)Did you try the following:
If(DefTaxCode <> 'N/A',TaxRate*[Act Year IFRSADJ])