Discussion Board for collaboration related to Creating Analytics for QlikView.
I am facing the same problem in my development, but i need to subtrct the two row from different columns in the same table.
Time 1 Time 2
Tatal 9 5 =4 (9-5)
Can you please suggest how can i write expression for 9-5= 4 and Multply 4 with some other number like 4*9=36.
Go to Solution.
You can use total function i.e
and for the multiplication with other number
Total(Sum(time1))- total(sum(time2) * 4 (any number you wnat)
Substract 2 different rows of a single table
=( sum(Time1) - sum(Time2) ) * 4
My problem is solved.
Thank You !