topic Re: Display multiple dates in combo chart in QlikView

Display multiple dates in combo chart

Tue, 28 Feb 2012 13:09:09 GMT

Activity	Begin	End	Date	Patient ID
00002	11-1-2011	4-10-2011	24-1-2011	1
00002	11-1-2011	4-10-2011	7-6-2011	1
00002	11-1-2011	4-10-2011	12-9-2011	1
00002	11-1-2011	4-10-2011	19-9-2011	1

Hi,

here is a little part of my data. The data is about patients. I would like to use a combochart and visualise each date with a symbol. Because i use patient ID as a dimension, the only thing i can come up with is display the first and last date. EG.

MinString ({$<Activity= {00002}> } Date -Begin). What function can I use to display all dates?

Thanx in advance.

Maartje

Display multiple dates in combo chart

CELAMBARASAN — Tue, 28 Feb 2012 13:21:48 GMT

Hi,

Try using Concat function

Concat({$<Activity= {00002}> } Date -Begin,',')

Hope it helps

Celambarasan

Display multiple dates in combo chart

Tue, 28 Feb 2012 13:30:42 GMT

Thanx for this quick answer! I think the function is very helpful. However, how do I get these 4 numbers (13,147,244,251) as symbols in my chart? Any idea?

Display multiple dates in combo chart

CELAMBARASAN — Tue, 28 Feb 2012 13:45:50 GMT

Hi,

I think its not possible?What is your dimension and can you tel me detail about your problem?

Celambarasan

Re: Display multiple dates in combo chart

sridhar240784 — Tue, 28 Feb 2012 15:36:15 GMT

Hi,

Hope i understood your question.

Check the attached application.

Your expression should be something like below.

=Dual(Concat(Aggr(sum(Date - Begin),Activity,Begin,End,Date),','),SUM(Date - Begin))

Hope this gives you an idea.

-Sridhar

Re: Display multiple dates in combo chart

Tue, 28 Feb 2012 16:12:22 GMT

Thanx for your help. Actually I would like to see for each date a different symbol. So in this axample for patient 1 4 dots (one after 13 days, one after 147 days, one after 244 and 251 days). And in your example also 4 symbols (dots) for patient 2.

Do you think this is possible?

Thanx in advance

Display multiple dates in combo chart

Wed, 07 Mar 2012 08:59:55 GMT

Actually i'm looking for a function like only(). Because there is an aggregation (dimension) on patient level, I need a function. However I would like to see all these 4 dates. What I can do is show the first-last, average but not just all 4 dates.

Anyone any idea?