Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Re: Displaying columns, fields from Excel as a chart.

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

Re: Displaying columns, fields from Excel as a chart.

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…

Re: Displaying columns, fields from Excel as a chart.

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

Re: Displaying columns, fields from Excel as a chart.

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…

Re: Displaying columns, fields from Excel as a chart.

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

Re: Displaying columns, fields from Excel as a chart.

Attached where?

Re: Displaying columns, fields from Excel as a chart.

A qvf is attached to my previous post.

-Rob

Not applicable

Re: Displaying columns, fields from Excel as a chart.

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

Not applicable

Re: Displaying columns, fields from Excel as a chart.

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...