topic Re: Filtering a bar chart in QlikView

Filtering a bar chart

Anonymous — Wed, 27 Dec 2017 16:53:02 GMT

Apologies for the basic question, completed my initial Qlikview training prior to Christmas and now putting it into practice.

I am building a basic dashboard to show the status of the hiring within our company. I have successfully loaded a spreadsheet of all the open hires. I would like to show a bar chart that shows only the hires that are 6+ months old. I have successfully added a bar chart to show all the hires, now need to filter it to show only the aged items. I would like this to be reflective of the selections made too (i.e. if UK selected then it shows the aged Cases for the UK only).

I presume I need to add a field in the data loader script that counts the days open and then I filter on this value somehow?

Re: Filtering a bar chart

mdmukramali — Wed, 27 Dec 2017 17:04:04 GMT

Hi Neil,

Can you attach the sample file so that we can help you in better way,

We need to know your Date field format and Etc.

Thanks,

Mukram

Re: Filtering a bar chart

Anonymous — Wed, 27 Dec 2017 17:23:43 GMT

Thanks for your response

Difficult really to add a sample file as its rather confidential hiring data. Assume there are just 3 columns and 300 rows of data

* Column 1 named 'ID' and this is the ID of the role in the resident HR system

* Column 2 named 'Hire Start' is a date field and this is the date the hiring commenced

* Column 3 named 'Current Stage' is the current stage (1 of 10 available) that the hire has reached

I have created a bar chart that shows the Count of hires by each hiring Stage.

I would like to filter the chart so it only shows the hires that are 6+ months old. So essentially the number of months between the 'Hire Start' date and todays date. Only show those that have a value of 6 or more

I presume I have to add a calculated field to the data loader that counts the months since 'Hire Start'?

Then somehow filter the bar chart to only show those with a value of 6+?

Re: Filtering a bar chart

Gysbert_Wassenaar — Wed, 27 Dec 2017 17:50:53 GMT

I presume I need to add a field in the data loader script that counts the days open and then I filter on this value somehow?

That's probably the easiest way. I assume you have an [date hired] kind of field. If so you could calculate its 'age' using something like: Today() - [date hired] as HiredDaysAgo.

You could also use a flag field: If(AddMonths(Today(),-6) > [date hired], 1, 0 ) as HiredMoreThan6MonthsAgo