topic Re: Proplem comparing year values in set analysis. in QlikView

Proplem comparing year values in set analysis.

Fri, 04 Oct 2013 09:04:02 GMT

I have a table with two different year entries:

LOAD

...

RX,

...

year(TIMESTAMP) as Year,

...

Num(left('$(db_schema)',4)) as Schema_Year,

FROM

Now I want to display how many datasets exists where the Year and Schema_Year differ.

I tried

='Schema_year != year :' & count({$< Schema_Year -= {Year}>} RX)

but that gives me the number of all records.

Thanks for your help.

tresB — Fri, 04 Oct 2013 09:19:17 GMT

Try like below:

Count(If(Year<>Schema_Year, RX)) // you may or may not want to use DISTINCT

Fri, 04 Oct 2013 09:58:29 GMT

Thanks tresesco but it does not work. The result is 0 but I know that there is one value different.

Maybe it has to do with the types?