products with versions

[#1]

I have products from A to E

and they all have different release versions.

A has release year of 2010 2011 2012 2013 2014

B had release year of 2012 2013 2014

C had release year of 2011 2012 2013 2014

D has release year of 2013 2014

E has release year of 2014

and my table is full of session logs of these 5 products.

I want to visualize the products that did not come out with releases including and after 2013.

I want to see decline of number of products that did not release versions including and after 2013.

so eventually the bar should be shorter and shorter since products will start to release new products.

date is the dimension.

and how should I visualize this?

on top of the chart itself. I want to visualize the product names that did not come out with new releases also.

Thank you!!

[#2]

Hi Anil,

basically, my rough logic is this,

Count ( Product_Name ) if Release_Year in (2010 or 2011 or 2012) and not in (2013 or 2014)

This is the count that i want.

Could you script it in a way that it will work in Qlikview?

Thanks!