topic products with versions in QlikView

products with versions

Wed, 25 Nov 2020 16:16:04 GMT

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!!

Re: products with versions

Wed, 03 Aug 2016 20:28:22 GMT

maybe something like..

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

Re: products with versions

sunny_talwar — Thu, 04 Aug 2016 05:27:54 GMT

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?

Re: products with versions

susovan — Thu, 04 Aug 2016 06:04:52 GMT

Hi David,

Is it your requirement?

Re: products with versions

Anil_Babu_Samineni — Thu, 04 Aug 2016 06:27:32 GMT

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))

Re: products with versions

Thu, 04 Aug 2016 16:58:18 GMT

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!

Re: products with versions

Thu, 04 Aug 2016 16:59:17 GMT

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

Re: products with versions

Thu, 04 Aug 2016 17:11:39 GMT

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

Re: products with versions

antoniotiman — Thu, 04 Aug 2016 17:26:43 GMT

Like this

Re: products with versions

Thu, 04 Aug 2016 17:45:36 GMT

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!

Re: products with versions

Thu, 04 Aug 2016 18:39:44 GMT

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!