Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

rish_sai
New Contributor III

how can find total for sales amount

Hi,

how can i subtract country sales for total linesalesamount and i should only see remaining balance in straight table.

Ex:   total linesalesamount is $13,321,238.07 and austria sales amount $408404.49,

here can i see remaining balance in straight table.

i'm trying .

plz help me out

Thanks in Advance.....

3 Replies

Re: how can find total for sales amount

Try like this

Sum({1}Sales)- sum(Sales)

Re: how can find total for sales amount

Try

Sum ( Sales )

/

Sum( Total Sales )

Elaborate more on the requirement.

Regards

Anand

Re: how can find total for sales amount

Hi,

Try like below,

Sum(Sales) - Sum(Total Sales)