expression for % variance

[#1]

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.

[Agis-Kalogiannis · Accepted solution]

Hi Thanasis

I think the expression you are looking for is

sum(item1)/sum(TOTAL item1)

Don't forget to click on the Relative check box on the Expressions tab.

Cheers

Agis