Set analysis with dimensions

Anonymous — Wed, 26 Apr 2017 19:18:59 GMT

Hi There,

Could you help me with the following?

I have a chart, with a date (settlement date) as dimension. and as expression the number of cases settled by that date (for example Jan 2016). The dimension is a group created with years, months, weeks.

I need to show all the number of cases that settled by Jan '16 / all cases that were closed in Jan '16

My problem is that all cases closed means all cases closed even the ones not settled (with date of settlement null to understand)

I have

Count (TOTAL {<CloseYear={$(=only(SettleYear)}, SettleYear>} DISTINCT CASE_ID)

but works only when I select the SettleYear, while I need to have it for each year .

I'm testing in a table with SettlYear as dimension and that as expression.

Re: Set analysis with dimensions

vinieme12 — Wed, 26 Apr 2017 19:37:44 GMT

Refer this document

set_analysis_intra-record.qvw

topic Re: Set analysis with dimensions in QlikView

Set analysis with dimensions

Re: Set analysis with dimensions