Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

baylor2016
Contributor

How to show these datapoints in the chart?

Hi Experts,

I can get patients number whose age is between 50 and 55 and visit our clinic in the last three years in given year month. Please refer to the sample app in the attachment. When a year and month is selected, the number of patients can be calculated. Right now I would like to show all the patient number by year month in the chart, how can I do it?

Please help.

Thanks

4 Replies

Re: How to show these datapoints in the chart?

What do you mean when you say without selecting YearMonth? You would not want to select 201611 below and still see 7?

Capture.PNG

baylor2016
Contributor

Re: How to show these datapoints in the chart?

I would like to show the patient numbers by Yearmonth in order to show a trend. Right now user can get the patient number for specific 'Yearmonth' by selecting it. Is there any way to use YearMonth in the dimension instead of using the yearMonth in the listbox?  Thanks

Re: How to show these datapoints in the chart?

I am difficulty in understanding the final goal here....Are you looking for this -> without selecting a yearMonth, you would want to see all patients which were between 50 and 55? Have you envisioned how the output will look like?

baylor2016
Contributor

Re: How to show these datapoints in the chart?

Yes. Instead of showing only one patient number (whose age is 50-55 and has a visit in past three years)  by user's selection, I would like to show the patient numbers for all the yearMonths. I would like show these data points either in bar chart or line chart. I am sorry about the confusion.