topic Re: Another set analysis period question in QlikView

Another set analysis period question

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

Hello

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

The variable for start period is vStartPeriod_CY (eg 201900), and I am trying to get to the range 201900 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)<=$(=vStartPeriod_CY + 09)"},
costc = {681,685},
bud2_line = {"OFFICE COSTS"},
Datasource = {'Actual'}
>} $(vCurrency)) * Infra%

Re: Another set analysis period question

sunny_talwar — Mon, 24 Feb 2020 18:37:48 GMT

May be try this

sum({$<period = {">=$(=vStartPeriod_CY)<=$(=vStartPeriod_CY + 09)"},
costc = {681,685},
bud2_line = {"OFFICE COSTS"},
Datasource = {'Actual'}
>} $(vCurrency)) * Infra%

Re: Another set analysis period question

Brett_Bleess — Thu, 26 Mar 2020 13:10:24 GMT

Paul, did Sunny's post get you what you needed? If so, please do not forget to return to your post and properly close it out by using the Accept as Solution button on Sunny's post to give him credit and let the other Members know that worked. If you did something different, please consider posting that and mark it to close out the thread.

Regards,
Brett