Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor III

Another set analysis period question

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%

Labels (1)
1 Solution

Accepted Solutions
Highlighted

Re: Another set analysis period question

May be try this

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

View solution in original post

2 Replies
Highlighted

Re: Another set analysis period question

May be try this

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

View solution in original post

Highlighted
Digital Support
Digital Support

Re: Another set analysis period question

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.