Discussion board where members can get started with Qlik Sense.
Good day experts!
I am new to qlik sense and I want to know how calculate tax based on tax table. I want do it in pivot chart.
This is the senarion, data1 contain fact data with columns:
Total is 120,000
data2 contains tax table with columns:
I will load the two tables in qlik sense then compute for the tax.
In my sheet using pivot table will create a
I appreciate your help.
Go to Solution.
Try with this expression
=Sum(Aggr(If(Sum(Earnings) > Range2, [Basic Tax], (Sum(Earnings) - Above(Range2))*[Excess(%)]), Name, (Range2, (NUMERIC))))
I will try the example and download sample qvf.
I will update if this is what i want.
Thank you so much Sunny.
This is exactly what I want.