Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

mikecrengland
Contributor III

$-sign Expansion frustration...

Hello All -

I can't figure this out... If I put these both into a text object:

=Date(Only({1<Cal.RelativeWeek = {'-18'}>} Cal.WeekStartMon),'MMM-D')

=$(=Date(Only({1<Cal.RelativeWeek = {'-18'}>} Cal.WeekStartMon),'MMM-D'))

The first one resolves to May-18 like I'd expect. but when I put it inside the $ sign, it doesn't work.

examp.PNG

What the heck am I doing wrong?

Thanks in advance,

Mike

4 Replies
lironbaram
Honored Contributor II

Re: $-sign Expansion frustration...

hi

why do you need the $ sign expression , why not use the first expression

in your case what happens is that

qlikview find the date and it's 18/5/2015

but then because of the $ sign its evaluates the expression as a formula

so the result is 18/5/2015 =

0.001787

and then the date function can't work

mikecrengland
Contributor III

Re: $-sign Expansion frustration...

I'm using it in a variable for a ValueList()

lironbaram
Honored Contributor II

Re: $-sign Expansion frustration...

look at my edited response

you should create a variable with the first expression , and then use it in the next variable

mikecrengland
Contributor III

Re: $-sign Expansion frustration...

That's what I've ended up with. I was hoping to avoid all of the extra variables.

Thanks,

Community Browser