topic Re: Script check! in QlikView

Script check!

Wed, 25 Nov 2020 16:16:04 GMT

if(Release='2015'

or Release='2016'

or Release='2014'

and ( Release <> '2017' and Release <> '2018') , count(distinct(Product_Name)))

I want count number of products that have releases before 2017 but does not have releases after 2017

What is wrong with my script here? I won't work. please help.

Re: Script check!

Mon, 08 Aug 2016 19:45:15 GMT

load count Distinc Product_Name as Qtd

from ... where

Release='2015'

or Release='2016'

or Release='2014'

and ( Release <> '2017' and Release <> '2018')

Re: Script check!

Mon, 08 Aug 2016 19:47:43 GMT

Hello David,

How about this (I assume you want to use this as a chart expression):

count({$<Release={">=2014<2017"}>} DISTINCT Product_Name)

BR,

Kuba

Re: Script check!

swuehl — Mon, 08 Aug 2016 19:49:57 GMT

Maybe like

Exclude:

LOAD Product as ProductToExclude

FROM YourtableSource

WHERE Release >=2017;

Result:

LOAD Count(DISTINCT Product) as ProductCount

FROM YourTableSource

WHERE NOT EXISTS( ProductToExclude, Product)

AND Release < 2017;

DROP TABLE Exclude;

Re: Script check!

Mon, 08 Aug 2016 19:53:04 GMT

yes I want to do it in chart expression. but in my real data there are releases that are named with character not just with numbers. can I specifically name them? not using range of number of years?

Re: Script check!

Mon, 08 Aug 2016 20:03:28 GMT

This will count all product_name, but only from 2017:

count({$<Release={'2017'}>} DISTINCT Product_Name)

This for example will count all, without those released in 2017 & 2018

count({$<Release={*}-{'2017','2018'}>} DISTINCT Product_Name)

Check below to get more info:

Set Analysis - Part 2 - Cool Stuff You Can Do (video)