Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
.
it seems like a very simple requirement. can you post a qvw that shows what you have so far?
-Rob
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…
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.
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…
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
Attached where?
A qvf is attached to my previous post.
-Rob
As in I have to log in to the website to see it…
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...