Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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