topic Problem in straight table using set analysis. in QlikView

Problem in straight table using set analysis.

Wed, 27 Jan 2016 06:54:38 GMT

I'm using the following example expression:

count({$<Status = {'Paid'}, Strike_Date -= {"<$(=vBank_Date)"}>} Amount)

It's hard to fully explain what this expression does, but it works.

Problem

I'm using a ContractID as a dimension. My variable /expression only works correctly when I select an individual contract number, it does not work in the chart. In the chart it just counts all the payments made per contract, instead of what I'm specifying.

How can I force this expression over each contractID instead of having to select a contract?

Kind Regards,

Re: Problem in straight table using set analysis.

p_verkooijen — Wed, 27 Jan 2016 08:46:34 GMT

You need to use AGGR

SUM(AGGR(

count({$<Status = {'Paid'}, Strike_Date -= {"<$(=vBank_Date)"}>} Amount)

, contractID

)

Also take a look at

QlikView Technical Brief - AGGR.docx

Also keep in mind that Set Analysis is performed before the chart calculation.

The used variable vBank_Date will be calculated as a overall date, not a date per contractID .

Re: Problem in straight table using set analysis.

tresB — Wed, 27 Jan 2016 08:47:34 GMT

How is your variable vBank_Date defined? Could you post a sample qvw?

Re: Problem in straight table using set analysis.

jagan — Wed, 27 Jan 2016 09:01:18 GMT

Hi,

I think the issue is with the variable vBank_Date you used in the expression, check whether it returns single or multiple or it is returning a valid date?

Regards,

jagan.