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

Displaying columns, fields from Excel as a chart.

I am trying to create a simple dashboard that shows me how may days are due to project deadlines. It is a simple spreadsheet with a column with the "Project Name" and a "Days Due" column. I want a bar graph that shows the project name on the X axis and the days due on the Y axis within a time that I specify. In other words each project has a total due date of 90 days. However I want see when the due date is less than 30 days away. I am hoping to do this based  on color.

Some coloring options. Bar is normally green, when the due date is <=20 then it turns orange, when the due date is <=15 days away the bar turns red. Graph Y axis should be detailed enough to see how many days are left when the due days gets to the 30 day mark. Or perhaps the X axis could display the project name and a numerical due days.

I can insert a table that shows the project names an the due dates. But the graphing part is not working .I can display the project names on the bottom of the graph and I can make bars appear on the graph but they do not reflect the data that is in the spreadsheet. The due date is just a number. I just want to display that number as a bar. I tried some of the functions. Count() makes each bar a value of 1, and Sum() makes a graph with plus and minus values. I don't know how to just display the number as it is. I am familiar with Excel functions but these are not the same.

DJ...

.

12 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

it seems like a very simple requirement. can you post a qvw that shows what you have so far?

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Not applicable
Author

If you could tell me what a “qvw” was. Otherwise here is a screenshot. Admittedly I have not gotten very far. In the end I will have four graphs like this one.

DJ…

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

I missed that this was Qlik Sense. Can you post the .qvf file? It will be in the

C:\Users\userid\Documents\Qlik\Sense\Apps

folder.

I would think a Sum([Days Due]) would work fine for the measure.

Not applicable
Author

The result of Sum() is that it counts the existence of the field, i.e. “1” hence the chart bars are all set to 1. I have yet to find a way to simply display the number as a bar in the graph.

DJ…

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Like I said, fairly simple requirement. But...things were getting messy because your Days Due field had a newline in it:

[ Days

Due]

This caused various problems in getting the expressions correct. i recreated your spreadsheet input using [Days Due] as fieldname and everything works fine. See attached.

-Rob

http://masterssummit.com

http://qlikviewcookbook.com

Not applicable
Author

Attached where?

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

A qvf is attached to my previous post.

-Rob

Not applicable
Author

As in I have to log in to the website to see it…

Not applicable
Author

Rob,

OK, I am logged onto the Quick website and looking at my Inbox. I am stupefied as to where to pick up the attachment you sent me! I see no button that says "Attachments" or any indication there is an attachment waiting. The "Action" selector only says "Was this helpful..."

I would very much like to see what you sent, but as to how to get it I am missing something here.

DJ...