topic Re: question about a dual field in QlikView

question about a dual field

Anonymous — Thu, 13 Aug 2015 17:31:27 GMT

Hi,

Month is a dual field. I'd like to use it in a set expression.

{<Month={'TextValue'}>} - this script works fine

e.g. {<Month={'Январь'}>}

{<Month={NumericValue}>} - this doesn't work

e.g. {<Month={1}>}

I need to base my set expression in a numeric value of Month for some reason.

Is it possible?

Thank you in advance,

Larisa

MK_QSL — Thu, 13 Aug 2015 17:44:29 GMT

Create two field like below

Month(Date) as Month,

Num(Month(Date)) as MonthID

Now use MonthID in your set expression.

sasiparupudi1 — Thu, 13 Aug 2015 18:18:44 GMT

try

{<Month={$(=Month(1))}>}

Anonymous — Thu, 13 Aug 2015 18:21:10 GMT

it results in null.

prabhu0505 — Thu, 13 Aug 2015 18:26:59 GMT

Pls try.

{<Num(Month)={NumericValue}>}

Anonymous — Thu, 13 Aug 2015 18:29:04 GMT

I results in error

sasiparupudi1 — Thu, 13 Aug 2015 18:47:45 GMT

is your month in the format like January,Febrauary,etc?

if yes then this should work

{<Month={"$(=Date(Month(1),'MMMM'))"}>}

sasiparupudi1 — Thu, 13 Aug 2015 19:07:19 GMT

Sorry, I think the expression should be

date(makedate(year(today()),11),'MMMMM')

{<Month={"$(=date(makedate(year(today()),2),'MMMMM'))"}>}

hth

Sasi