Filtering a bar chart

[Anonymous]

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?

[mdmukramali]

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

[Anonymous]

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+?

[Gysbert_Wassenaar]

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