topic Sum by catogary in QlikView

Sum by catogary

techvarun — Tue, 16 Jul 2013 08:15:40 GMT

I have a staraight table with the following fields and i need to display the difference of

sum(totalamaunt) where catogay cost and

sum(totalamount) where catogary Payable

Thanks in advance

kaushiknsolanki — Tue, 16 Jul 2013 08:43:18 GMT

Hi,

Remove the dimension Category and add this expressions.

1. Sum({<Category = {"Costs"}>}TotalAMount)

2. Sum({<Category = {"Payable"}>}TotalAMount)

3. Column(1) - Column(2)

Regards,

Kaushik Solanki

techvarun — Tue, 16 Jul 2013 09:54:43 GMT

It Works here is my final Script

=(Sum({<Category={'Costs'}>} [Total (Amount)]) - Sum({<Category={'Revenue'}>} [Total (Amount)]))

Regards

techvarun — Tue, 16 Jul 2013 12:11:28 GMT

One more question what if i need to add one more condition like the month should be may?

Regards

kaushiknsolanki — Tue, 16 Jul 2013 12:23:42 GMT

HI,

Then it will be something like this.

Sum({<Category = {"Costs"},Month = {"May"}>}TotalAMount)

Regards,

Kaushik Solanki