topic compare PERIOD with text in QlikView

compare PERIOD with text

Fri, 05 Feb 2010 14:22:59 GMT

Hi all,

I try to compare period with text, so I try to conver date that I make from MAKEDATE function to num (because [Period] return in number although it show in Text like Nov-2008).

But it return num from date not period.

[Period]={">=$(=NUM(DATE(MAKEDATE(CONT_START_YEAR,CONT_START_MONTH),'MMM-YYYY'))) and <=$(=NUM(DATE(ADDMONTHS(MAKEDATE(CONT_START_YEAR,CONT_START_MONTH),6),'MMM-YYYY')))"}

Thank you so much

compare PERIOD with text

vidyut — Fri, 05 Feb 2010 15:47:57 GMT

Try using the Text() Function instead of Num().

compare PERIOD with text

Sat, 06 Feb 2010 03:33:30 GMT

Many thanks Vidyut Verma

But [Period] return in number, so it cannot match text with it.

When I test in text object return like >>>

[Period]={">=Nov-2008 and <=Dec 2008"}

What I try to do is >>>>

[Period]={">=192830 and <=2948924"}

Thank you so much

compare PERIOD with text

sathishkumar_go — Sat, 06 Feb 2010 09:55:50 GMT

use this

[Period]={">=$(=(DATE(MAKEDATE(CONT_START_YEAR,CONT_START_MONTH),'MMM-YYYY'))) and <=$(=(DATE(ADDMONTHS(MAKEDATE(CONT_START_YEAR,CONT_START_MONTH),6),'MMM-YYYY')))"}

-Sathish

compare PERIOD with text

Sat, 06 Feb 2010 12:23:46 GMT

Thank you so much Sathish

It still doesn't work becase I test in text object and the return is >>>

[Period] = {">= Nov-2008 and Dec-2008"}

although DATE() function return in number. (I don't know why )

This case will be correct if it return number of PERIOD

or any suggestion?

--- Thanks you so much ----

compare PERIOD with text

sathishkumar_go — Sat, 06 Feb 2010 12:35:41 GMT

do 1 thing just use this

DATE(MAKEDATE(CONT_START_YEAR,CONT_START_MONTH),'MMM-YYYY') as Month1

in load statement(script part) after put listbox in month1.

check month1 is number or date format?

-Sathish

compare PERIOD with text

Sat, 06 Feb 2010 16:02:50 GMT

Thank you so much Sathish

It's number but it show in date format.

And PERIOD can use = to compare

But cannot use >= or <=

Many thanks

compare PERIOD with text

Tue, 09 Feb 2010 08:52:37 GMT

Hi all,

I'hv got a way for this solution.

Thank you so much for your help.