Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

bromijn
New Contributor II

Rowno() / Synthetic dimensions and set anaylises

Hi,

I created a synthetic dimension (1 to 10). Based on a startdate I would like to have rolling period.

So startdate + 1,startdate + 2.

From what I know you cannot use a synthetic dimension in a set analysis. So I tried to use Rowno() instead.

This expression workfine whitout re-calculating it $(= ..)

$(=date(addmonths(makedate(2013,01),RowNo()),'YYYYMM'))

(Count({1<PARTY_ID=Cohort_1:Smiley TongueARTY_ID,

YEARMONTH={'$(=date(addmonths(makedate(2013,01),RowNo()),'YYYYMM'))' } >}PARTY_ID)

Thanks,

Ben

1 Reply
Not applicable

Re: Rowno() / Synthetic dimensions and set anaylises

Hi Ben, Why you are using Synthetic Dimension here ? What is your actual requirement ?

Your dimension id tied the STARTDATE , so you can create the new field on the data model  and use the new field in your chart.

Can you please post sample qvw here ?

Community Browser