Discussion Board for collaboration related to Qlik Education.
my target is to make a comparison %not by line but by column.
as you see in the attached excel file , i have some totals in line 17 and i want to do the % comparisson with the numbers above them.
doing that in excel file is easy but i dont know the expression yet for the qlick.
Go to Solution.
I think the expression you are looking for is
Don't forget to click on the Relative check box on the Expressions tab.