Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Display multiple dates in combo chart

ActivityBeginEndDatePatient ID
0000211-1-20114-10-201124-1-20111
0000211-1-20114-10-20117-6-20111
0000211-1-20114-10-201112-9-20111
0000211-1-20114-10-201119-9-20111

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




6 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Try using Concat function

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

Hope it helps

Celambarasan

Not applicable
Author

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?

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

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

Celambarasan

sridhar240784
Creator III
Creator III

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

Not applicable
Author

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

Not applicable
Author

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?