Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

expression for % variance

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.

1 Solution

Accepted Solutions
Employee
Employee

Re: expression for % variance

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

1 Reply
Employee
Employee

Re: expression for % variance

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

Community Browser