topic How to use domain value in set analysis? in QlikView

How to use domain value in set analysis?

baylor2016 — Fri, 21 Apr 2017 17:11:46 GMT

Hi,

I am able to use the following syntax to get the number of patient's visit within three years before the date user selected. Now I would like to get the numbers of visits by year and month and display them in a bar chart. The user selected date becomes year and month in the x-axis. I am sure it can be done, but I do not know how. My questions is to display the number of records three years before the date on the x-axis.

=count(DISTINCT {$<
FLAG_DM={1},
ENCOUNTERAGE={'>17<76'},
CONTACT_DATE2 = {"$(='>=' & Date(V_selectedDate_3YearAgo) & '<=' & Date(V_selectedDate))"}
>}PAT_ENC_CSN_ID)

Thanks

Longmatch

Re: How to use domain value in set analysis?

kaushiknsolanki — Fri, 21 Apr 2017 17:23:44 GMT

Hi,

I hope you have got the right date in variable.

If yes then try below expression.

=count(DISTINCT {$<
FLAG_DM={1},
ENCOUNTERAGE={'>17<76'},
CONTACT_DATE2 = {">=$(=Date(V_selectedDate_3YearAgo))<=$(=Date(V_selectedDate))"}
>}PAT_ENC_CSN_ID)

Regards,

Kaushik Solanki

Re: How to use domain value in set analysis?

baylor2016 — Fri, 21 Apr 2017 17:33:50 GMT

I might not state my questions clearly enough. What I want is to display number of records in the past three years based upon the year month in x-axis. The variable of V_selectedDate_3YearAgo and V_selectedDate will not be used.

Re: How to use domain value in set analysis?

kaushiknsolanki — Fri, 21 Apr 2017 17:37:47 GMT

Hi,

It would be helpful if you give sample data along with the required output.

Regards,

Kaushik Solanki