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]

maybe something like..

if(NewRelease = ('2010' or '2011' or '2012') and NewRelease != ('2013'or '2014'), Product_Name)  ???

[sunny_talwar]

Hey David, I am not sure I completely understand what you are wanting to do. Would you be able to provide a sample or what you might be looking for?

[susovan]

Hi David,

Is it your requirement?

[Anil_Babu_Samineni]

Might be this,

If(Match(Aggr(Sum({<Product = {'A'}, Year = {'2010','2011','2012','2013','2014'} >}Sales) and Sum({<Product = {'B'}, Year = {'2012','2013','2014'} >}Sales) and Sum({<Product = {'C'}, Year = {'2011','2012','2013','2014'} >}Sales) and Sum({<Product = {'D'}, Year = {'2013','2014'} >}Sales) and Sum({<Product = {'E'}, Year = {'2014'} >}Sales),Product),Year))

[#6]

I think I should explain this again.

all products' releases including and after 2013 is using are using are regarded as group A

all products' releases before 2012 are regarded group B

for example QlikStrong 2010, QlikStrong 2011, QlikStrong 2012 are group B and Qlikstrong 2013 and QlikStrong 2014 are Group A. and of course above mentioned name of the product is combination of "Product Name" and "Release Year"

so in  data table the Product Name would be just QlikStrong and Release Year columns will have all those 2010 2011 2012 2013 2014 somewhere all across the data table.

Let's say there are QlikStrong, QlikMediocre, QlikWeak.

I want to see how many products have not still moved from Group B to Group A.

QlikStrong has releases 2010 2011 2012 2013 2014

QlikMedicore has releases 2010 2011 2012 2014

QlikWeak has releases 2010 2011 2012

This is the view that I would want to see.

so in 2013 I know instantly know that QM and QW are the products that should be encouraged to move to group A. and in 2014 QW is the only product that should be encouraged to move to group A. this will visualize what target audience that I have.

before 2012, since Group A is only the releases that are including and after 2013, no product is in Group A Thus, all the products are our target audience to encourage to move to group A.

I tried to explain this to the best of my ability but I understand that it could be hard to understand.

Our goal is to encourage every products to be in Group A and when that time comes, the value in the chart will be 0 which mean goal succeeded.

Thank you!

[#7]

Please refer to my above reply to Sunny T. Thank you for taking time to answer my question! I should have explained better.

[#8]

basically the view that I want visualize is to show the gap that is described as red line in below diagram.

[antoniotiman]

Like this

[#10]

Hi Antonio Mancini,

the dimension is an actual Year as time. and release year is the version. so the view that I want to see should be decreasing as time goes by.

Thanks!