Sense: Set Analysis with variable

[kris_vliegen]

Hello All,

I'm  new to Sense. And I wan't to use set analysis with a variable in a pivot table.

I've created a pivot table with 2 measures. Onde with the data of this year and one withe the data of last year.

Now I get in both columns the same value.

I've created 2 variables. like below.

In the pivot table I created 2 measures:

For last year:

expression : sum({ $ <HrAPKO={ 'A' }, Boekjaar = {'(=$(vLastYear))'}>}Bedrag)

For this year

expression sum({ $ <HrAPKO={ 'A' }>}Bedrag).

Why does the year selection not work?

regards,

Kris

[marcus_sommer]

Try to include the current year within the set analysis, too like:

sum({ $ <HrAPKO={ 'A' }, Boekjaar = {'(=$(vYear))'}>}Bedrag)

- Marcus

[Anil_Babu_Samineni]

You may forget to add this?

sum({ $ <HrAPKO={ 'A' }, Boekjaar = {'(=$(vYear))'}>}Bedrag)

[kris_vliegen]

Hi Marcus,

Indeed, I've added the set analysis instruction to the measure for this year.

But I had selected 2017 so this data was correct.

I only see the data for 2017 in the column of last year (2016) an the column of this year (2017)

regards,

Kris

[marcus_sommer · Accepted solution]

Try a change by the variable-call like:

sum({ $ <HrAPKO={ 'A' }, Boekjaar = {$(vYear)}>}Bedrag)

sum({ $ <HrAPKO={ 'A' }, Boekjaar = {$(vLastYear)}>}Bedrag)

- Marcus

[kris_vliegen]

Thanks marcus.

This works for me.

Regards,

Kris

[#7]

Try the below expressions,

Sum({$<HrAPKO={ 'A' },Boekjaar={'=Boekjaar=$(vLastYear)'}>}Bedrag)

Sum({$<HrAPKO={ 'A' },Boekjaar={'=Boekjaar=$(vYear)'}>}Bedrag)