Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Champion III
Champion III

Refer this document


set_analysis_intra-record.qvw

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

1 Reply
vinieme12
Champion III
Champion III

Refer this document


set_analysis_intra-record.qvw

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.