topic Re: Filtered Sum in pivot table in QlikView

Filtered Sum in pivot table

Wed, 25 Nov 2020 16:16:04 GMT

Hi!

I am struggling to do som basic summaries in my charts..

I want to create a chart that shows the sums of income from interest rate greater than 3000 for each month

something like show in chart when 'sum(transactionamount) when transactioncategory(A,B) >= 3000'

So if the sum of transactionamounts in transactioncategories A an B is greater or equal to 3000, it will show in the chart.

What is the best sollution? Should I create a new variable for the summed category of interest income? Can I make a generalised sum expression, and show to filter on values greater than 3000 directly in the chart? I am not quite sure if 3000 is the amount that I want to filter on, so how to make this as flexible as possible?

What would you, clever people, do?

Re: Filtered Sum in pivot table

Anil_Babu_Samineni — Thu, 22 Jun 2017 16:20:12 GMT

May be this?

Sum({<[interest rate] = {'>=3000'}>} income)

Re: Filtered Sum in pivot table

vishsaggi — Thu, 22 Jun 2017 16:46:43 GMT

Extending Anil's expr: You can add your TranCategory like this:

= Sum({< InterestRate = {'>3000'}, TranCategory = {'A', 'B'} >} Amount)

Re: Filtered Sum in pivot table

Kushal_Chawda — Thu, 22 Jun 2017 16:46:49 GMT

Data:

LOAD *,

rowno() as Row

FROM Table;

Expression:

=sum({<Row={"=sum({<transactioncategory={'A','B'}>}transactionamount)>3000"}>}transactionamount)