Show bars only for distinct products not part of all the previous years

[Anononymous13]

I am trying to create a bar chart which shows products that only appear in the given year and it did not appear in any of the previous years.  i.e., The year 2016 should only have 9 unique products and product 1 should only appear in year 2015.  Would it be possible to implement that in QLikview?

[raji6763]

hi,

your data itself having product 1 appear for all years  .

Is there any column like product ID?

if the product id column appears in your data,then use it.

count(distinct Product ID)

regards,

raji

[Anononymous13]

Product 1 appears in all years but I want it to only appear in the year it first appeared. i.e., all products should only appear in their min(year)

[vamsee · Accepted solution]

Created a flag based on the script level and used it in expressions

[Anononymous13]

Thank you. What if year is in different table and product in different table, how can I load the script by creating new column as key.

[vamsee]

I would suggest you create a temporary column Year in the fact table, which I assume is joined with the calendar table based on date