Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Created a flag based on the script level and used it in expressions
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
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)
Created a flag based on the script level and used it in expressions
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.
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