Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis in Calculation (Multiplication)

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

11 Replies
nagaiank
Specialist III
Specialist III

Did you try the following:

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

avinashelite

Hi Christian,

Can you please share your app ??