topic Re: Why is mod() failing? in QlikView

Why is mod() failing?

Thu, 30 Jan 2014 01:50:51 GMT

This expression shows nothing in my chart:

Mod(WeekDay(Min(timestamp)) + 2.5, 7)

But these two expressions render expected values:

Mod(WeekDay(Min(timestamp)) + 2, 7)

WeekDay(Min(timestamp)) + 2.5

Why is Mod() failing in the first expression?

Also some bonus points questions: 1. Is there a way to see what the underlying error in a chart is, instead of a blank chart? 2. Is using Mod() or NumMin() just as bad as using If() in terms of chart performance?

Many Thanks,

Paul

Re: Why is mod() failing?

Anonymous — Thu, 30 Jan 2014 01:58:01 GMT

Don't know why it doesn't work but will FMod(WeekDay(Min(timestamp)) + 2.5, 7) work? It may be because its not interpreting the first input as an integer.

Mod(num((WeekDay(Min(timestamp))) + 2.5, 7)

Re: Why is mod() failing?

Thu, 30 Jan 2014 02:05:29 GMT

FMod() works perfectly, thanks for the fast response!