topic Re: num(month(date)) in QlikView

num(month(date))

Tue, 17 Mar 2015 13:00:19 GMT

in calendar i have month sequence column - created using num(month(date)) as monSeq

now i want to use set analysis to get previous month .

i use - monSeq={">=$(=max(monSeq)-1)<=$(=max(monSeq))"}

i am not clear with what number we are subtracting ?

is it date / week / month

behavior for today date:

=max(monSeq)-1) -> march

=max(monSeq)-2)

-> march

=max(monSeq)-3)

-> march

=max(monSeq)-4)

-> feb

can anybody please guide me , what are these number (number that we are subtracting) means day or week or month

Gysbert_Wassenaar — Tue, 17 Mar 2015 13:23:20 GMT

Without looking at the actual data we can't give you a definite answer. But my first guess would be month numbers.

robert_mika — Tue, 17 Mar 2015 13:25:39 GMT

What's your data format?

As this

will give different value that this:

Tue, 17 Mar 2015 13:40:26 GMT

'2015-03-17'

robert_mika — Tue, 17 Mar 2015 13:51:35 GMT

Please post sample of your data so we can better understand what we are dealing with.