topic Re: <= in my table expression does not function in QlikView

<= in my table expression does not function

pacoli2013 — Fri, 30 Jun 2017 09:35:56 GMT

Hello

I have a straight table, Dimension auftrag + positionsnummer

I have several date - filters

In my fact table I have joined several fields to make if-statements in my straight table

I Need if-statements because in the same table I will have some TEXT-Fields (like Lieferart) so AGGR-functions doesn't work

In the table I have an Expression Versanddatum with following if Statement:

/* 20) Year and Month */
if (Isl_YearMonth <= (Year&Month), Versanddatum,

/* 21) Year and Week */
if (Isl_YearWeek <= (Year&Week), Versanddatum,

/* 22) Year and DayShortName */
if (Isl_YearWeekdayShortName <= (Year&DayShortName), Versanddatum,

/* 23) Year and Day */
if (Isl_YearMonthDay <= (Year&Day), Versanddatum,

/* 24) Year */
if (Isl_Year <= (Year), Versanddatum
)))))

the = part functions the < part not

I hope someone can explain me why or why on?

Are such Statements possible at All?

Is there an other solution?

Thanks in advance

Regards

Court

Re: <= in my table expression does not function

marcus_sommer — Fri, 30 Jun 2017 10:36:42 GMT

It didn't work because you tried to use a numerical operator for string-values. Instead of <> you could try it with precedes or follows as operators.

Beside them I wouldn't use string-values for it and I'm not sure if the whole approach to control dimensions/expressions with so many date-fields is really handy - at least I would use dual(string, number) for these fields.

- Marcus

Re: <= in my table expression does not function

pacoli2013 — Fri, 30 Jun 2017 12:27:42 GMT

Danke Marcus

Will es mahl testen

aber denke es wird ein normale straight tabel ohne if-statements und nur jahr-filters

Court