topic Re: set analysis not working in App Development

set analysis not working

lynn2 — Wed, 10 May 2023 03:28:16 GMT

Hi all, I'm new to Qlik and I can't seem to get my set analysis to work. I'm trying to count the number of instances where the dimension returns a specific value. Here's my expression:

Count({<[MILESTONE_STEP] = {"APPLICATION_DRAFT_CREATED"}>}[MILESTONE_SUMMARY.MILESTONE_STEP_ID])

The expression seem correct and is able to be applied. However the count returned is not meeting the condition stated, it just returns the total count

Re: set analysis not working

techguy100 — Wed, 10 May 2023 05:17:06 GMT

Based on the expression you provided, it looks like the set analysis is correctly filtering the [MILESTONE_SUMMARY.MILESTONE_STEP_ID] field based on the condition [MILESTONE_STEP] = {"APPLICATION_DRAFT_CREATED"}.

However, it's possible that the issue lies with the [MILESTONE_STEP] field itself. Double-check that the [MILESTONE_STEP] field is in the same data model as the [MILESTONE_SUMMARY.MILESTONE_STEP_ID] field, and that the [MILESTONE_STEP] values match exactly with {"APPLICATION_DRAFT_CREATED"} (i.e. check for any whitespace or other formatting issues).

Another possibility is that there may be other filters being applied to the chart or table where the expression is being used. Try removing any other filters to see if that affects the count.

If neither of these solutions work, it may be helpful to provide more information about your data model and the chart or table where the expression is being used, so that others can better understand the issue and provide more targeted assistance.

Regards,

Rachel Gomez

Re: set analysis not working

Chanty4u — Wed, 10 May 2023 05:48:29 GMT

Try this

Count({<[MILESTONE_STEP] = {"APPLICATION_DRAFT_CREATED"}>} DISTINCT [MILESTONE_STEP])

Re: set analysis not working

BrunPierre — Wed, 10 May 2023 05:50:52 GMT

@techguy100 Is it possible that you are failing to count the expression's unique values?

Count( DISTINCT {<[MILESTONE_STEP] = {"APPLICATION_DRAFT_CREATED"}>}[MILESTONE_SUMMARY.MILESTONE_STEP_ID])

Re: set analysis not working

lynn2 — Wed, 10 May 2023 09:55:38 GMT

hey @techguy100, thanks for replying. I've checked the formatting & filters, all seems okay. I'm investigating my data model and seems like the issue lies with counting the null values. I've rewritten my expression to the following but it doesnt seem to be picking up the 2nd condition

Count({<[MILESTONE_STEP] = {"APPLICATION_DRAFT_CREATED"}, [MILESTONE_STEP_ID]-={"'-'"}>}DISTINCT [MILESTONE_SUMMARY.MILESTONE_STEP_ID])

Here's a screenshot of sample data from my data model:

Re: set analysis not working

lynn2 — Wed, 10 May 2023 09:58:16 GMT

Hey @Chanty4u, thanks for replying. The DISTINCT syntax did help with counting distinct values only, thanks for pointing that out. However I'm still getting an error, believe that my expression is counting the null values. I've changed it to this but it doesnt seem to be meeting the 2nd condition

Count({<[MILESTONE_STEP] = {"APPLICATION_DRAFT_CREATED"}, [MILESTONE_STEP_ID]-={"'-'"}>}DISTINCT [MILESTONE_SUMMARY.MILESTONE_STEP_ID])

Here's a screenshot of sample data from my data model:

Re: set analysis not working

lynn2 — Wed, 10 May 2023 10:00:59 GMT

Hey @BrunPierre, thanks for replying. I added the DISTINCT syntax at [MILESTONE_SUMMARY.MILESTONE_STEP_ID] and it seems to work. Should there be another DISTINCT syntax at the front?

Re: set analysis not working

BrunPierre — Wed, 10 May 2023 11:42:41 GMT

Hi, one is enough, either place it in front or behind the set expression.