Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
pacoli2013
Creator
Creator

<= in my table expression does not function

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

2 Replies
marcus_sommer

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

pacoli2013
Creator
Creator
Author

Danke Marcus

Will es mahl testen

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

Court