Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Problem Number/Character?

I Have defined

weekNrSysDate='02';

i have a query where column is:

to_char(datecolumn,'iw') as BWeeknr

THEN i have

Expression:

=Sum( {<BMIYEAR={"$(Yearcompare)"},BMIWEEKNR={"$(WeekNrSysDate)"}>} SALES)

yearcompare is character value

but when i now define

WeekNrSysDate=0;

and query:

to_number(to_char(datecolumn,'iw')) as BWeeknr

my expression won't work?

i don't know why?

1 Reply

Re: Problem Number/Character?

please provide sample app

thanks

regards

Marco

Community Browser