topic Re: Set Analysis Comparing two fields in QlikView

Set Analysis Comparing two fields

tchovanec — Tue, 05 Mar 2013 18:57:06 GMT

I am trying to use the following set analysis but I am getting no results. Are you unable to compare one field to another?


  
COUNT(
{<
ADMIT_DT= {">= $(=NUM(ADDMONTHS(MONTHSTART(DOB),12)))"}
>}
DISTINCT MRN
) 
ADMIT_DT is a number. Any help would be greatly appreciated? Thank you

Re: Set Analysis Comparing two fields

Gysbert_Wassenaar — Tue, 05 Mar 2013 19:18:09 GMT

ADMIN_DT and DOB shouldn't be dimensions in your chart. Set analysis expressions are calculated once per chart, not per row. You'll have to use an if statement instead if you use ADMIN_DT or DOB as a dimension in your chart and you don't select only one value. Something like :

COUNT(DISTINCT if(ADMIT_DT >= ADDMONTHS(MONTHSTART(DOB),12),MRN))

Re: Set Analysis Comparing two fields

tchovanec — Tue, 05 Mar 2013 19:31:09 GMT

Use an if statement where? I am unsure of what you are saying. Thanks.