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: 
MatthewShirey
Contributor
Contributor

Help with Bar Graph

Hello community,

I have a problem I cant seem to figure out in an app I am developing. I am trying to create a bar graph with two bars. The x axis is the date, and the two bars are both requestor and donor.  So for instance, when I would filter down to just see Matt as a name, I would see two bars on 4/1/2021, one for requestor and one for donor side by side.   When I go to develop this in qlik it only allows me to display Requestor. Even when I use this equation : Count({<[Opened Date]={">=$(=date(addmonths(max([Opened Date])),'M/D/YYYY'))"}>} [Donor Name])  it still displays requestor name.  Does anyone know a workaround for this? Thank you in advance.  below is a screenshot of the issue I am having. 

DateRequestor NameDonor Name
4/1/2021MattSteve
4/1/2021SamMatt
4/1/2021SteveTom
4/1/2021TomSam

 

problem.PNG

1 Reply
mato32188
Specialist
Specialist

Hi @MatthewShirey ,

what you need to do is to create separate table with linked field to both of existing fields (Requestor and Donor).

core_table:
load
Date,
Requestor&'-'&Donor as NameLinkKey,
Requestor,
Donor,
Requestor&';'&Donor as JoinedNames
Inline [
Date,Requestor,Donor
04/01/2021,Matt,Steve
04/01/2021,Sam,Matt
04/01/2021,Steve,Tom
04/01/2021,Tom,Sam
];

names:
load
NameLinkKey,
SubField(JoinedNames,';') as Name
Resident tmp;

drop fields JoinedNames;

Then use field Name as a filter.

BR

m

ECG line chart is the most important visualization in your life.