topic Reported Date & Completed Date in a Single List box in QlikView

Reported Date & Completed Date in a Single List box

Sat, 07 Feb 2015 09:28:06 GMT

Hello All,

In an incident dump, we have incidents reported for the month of Jan 2015. [Reported Date Column]

Also the incidents closed for the month Jan 2015 which can be created in 2014 & Jan 2015 also.[Completed Date Column]

Now i need to have a list box of years 2014 2015 . selecting 2015 should show the Incidents Reported & Incident Closed in the Bar Chart.

Reported Date & Completed Date are two different columns.

How can i have the list box of Year which should take care of both [Incident Reported & Incident Closed].

Can you please suggest me. Appreciate your valued response.

Thanks,

Sasikumar

Anonymous — Sat, 07 Feb 2015 11:25:40 GMT

Hi,

Data:

Load *,

[Reported Date Column] as [Date Column]

From Table;

concatenate

Load *,

[Completed Date Column] as [Date Column]

From Table;

Final:

noconcatenate

Load *,

Year([Date Column]) as Year

From Data;

Use Year Column in Listbox,when user makes a selection,Incidents Reported & Incidents Closed will be displayed on year selected.