topic Re: Converting numbers to date in QlikView

Converting numbers to date

Anonymous — Wed, 19 Jul 2017 02:29:43 GMT

Hey, I cant get the right value using this expression

=if(Date(mydate,'MMM-YY') = 'Jun-2017',1, 0)

if I select 1 date it will give me the right one, but if select more than 1 it give me zero

The field 'mydate' is in numbers format

Re: Converting numbers to date

rwunderlich — Wed, 19 Jul 2017 02:42:32 GMT

The expression will be false if there is more than one date.

-Rob

Re: Converting numbers to date

Anonymous — Wed, 19 Jul 2017 02:54:07 GMT

yes, that's why i am asking what should i do to make it right if there is more than one date selected

Re: Converting numbers to date

arvind_patil — Wed, 19 Jul 2017 02:56:17 GMT

Hi Mike,

I think you need to create master calendar and calculate monthyear field then it works if you selected month year then it shows all respective date.

Thanks,

Arvind Patil

Re: Converting numbers to date

passionate — Wed, 19 Jul 2017 04:28:50 GMT

Hi,

Do you want this in script :

PFA, Solution in Script.

Create a numeric value for date and use this Numeric value in expression.

Regards,

Pankaj

Re: Converting numbers to date

balar025 — Wed, 19 Jul 2017 05:11:39 GMT

Hi,

You can use below function

if(Num(mydate)>=Num(MakeDate(2017,06,01)) and Num(mydate)<=Num(MakeDate(2017,06,30)),1,0)

Regards,

Ravi balar

Re: Converting numbers to date

tresB — Wed, 19 Jul 2017 05:23:46 GMT

May be this?

=Max(if(Date(mydate,'MMM-YY') = 'Jun-2017',1, 0))

Re: Converting numbers to date

rwunderlich — Wed, 19 Jul 2017 05:44:53 GMT

What context do you want to make this test in? You want it to be true if the date "Jun-2017" exists in the selection? Or you only want to aggregate rows where that is true? Is this an expression in a chart or some other expression?

-Rob