topic Re: Exclude min value from Dimension in QlikView

Exclude min value from Dimension

Anononymous13 — Wed, 25 Nov 2020 16:16:04 GMT

Hello Qlik experts ,

I am trying to create a chart to show the first appearance of a product in the market.

I used the expression =aggr({<[Year]=>}Min([Year]),[product]) in my Dimension to show all the products and their min year and the data on the bar chart appears correctly.

Now I would want to exclude the year '2015' from the Dimension and show only the products that appeared for the first time between 2016 to 2020, when I try to use the expression aggr({<[Year]=>}min({$<[Year]={'<>2015'}>} [Year]),[Product])

the values for 2015 and 2016 are adding up in the bar chart. Could anybody please help me with the issue.

Re: Exclude min value from Dimension

rubenmarin — Sat, 25 Jul 2020 09:18:51 GMT

Hi, ycan you try this?: =aggr({<[Year]-={2015}>}Min([Year]),[product])

Or use a simple Year and product as dimensions and set the logic in expression:

Count({<Year-={2015}>}Aggr(if(Min(TOTAL <product> Year)=Year, product), product, Year))

Re: Exclude min value from Dimension

Anononymous13 — Sun, 26 Jul 2020 04:00:35 GMT

Hello @rubenmarin ,

Thank you. Count({<Year-={2015}>}Aggr(if(Min(TOTAL <product> Year)=Year, product), product, Year)) works however when I select the Year filter , the values adds up again.

Re: Exclude min value from Dimension

rubenmarin — Sun, 26 Jul 2020 08:33:19 GMT

Ok, I added a clause to ignore selections when calcualtes the min year of each product:

Count({<Year-={2015}>}Aggr(if(Min({1} TOTAL <product> Year)=Year, product), product, Year))

Re: Exclude min value from Dimension

Anononymous13 — Mon, 27 Jul 2020 12:28:20 GMT

Thank you @rubenmarin , it works.