topic Set analysis - calculating a period in QlikView

Set analysis - calculating a period

paul_ripley — Sat, 16 Nov 2024 01:12:25 GMT

Hello

I am trying to do some set analysis within a table, I want to take the start period and 9

The variable for start period is vStartPeriod_CY (eg 201900), and I am trying to get to 201909 into the set analysis

For example I tried the below but it didnt seem to work. Can you see what i am doing wrong ?

Many thanks Paul

=sum({$<period = {"=$(vStartPeriod_CY)+09"},
team_description -= {'P&P','IT'},
Datasource = {'Actual'}, busarea = {PC}
>} $(vCurrency))

sunny_talwar — Mon, 24 Feb 2020 14:49:07 GMT

May be try this

=Sum({$<period = {"$(=vStartPeriod_CY + 9)"}, team_description -= {'P&P','IT'}, Datasource = {'Actual'}, busarea = {PC} >} $(vCurrency))

paul_ripley — Mon, 24 Feb 2020 14:54:29 GMT

Hi Sunny

Many thanks for your help

Paul