Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
francesco_leoni
New Contributor

Set analysis with dimensions

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.

1 Solution

Accepted Solutions
vinieme12
Esteemed Contributor II

Re: Set analysis with dimensions

Refer this document


set_analysis_intra-record.qvw

1 Reply
vinieme12
Esteemed Contributor II

Re: Set analysis with dimensions

Refer this document


set_analysis_intra-record.qvw