topic Re: Sense: Set Analysis with variable in QlikView

Sense: Set Analysis with variable

kris_vliegen — Tue, 21 Mar 2017 12:09:14 GMT

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

Re: Sense: Set Analysis with variable

marcus_sommer — Tue, 21 Mar 2017 12:16:02 GMT

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

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

- Marcus

Re: Sense: Set Analysis with variable

Anil_Babu_Samineni — Tue, 21 Mar 2017 12:18:23 GMT

You may forget to add this?

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

Re: Sense: Set Analysis with variable

kris_vliegen — Tue, 21 Mar 2017 12:21:07 GMT

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

Re: Sense: Set Analysis with variable

marcus_sommer — Tue, 21 Mar 2017 12:36:59 GMT

Try a change by the variable-call like:

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

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

- Marcus

Re: Sense: Set Analysis with variable

kris_vliegen — Tue, 21 Mar 2017 12:40:37 GMT

Thanks marcus.

This works for me.

Regards,

Kris

Re: Sense: Set Analysis with variable

Tue, 21 Mar 2017 12:48:36 GMT

Try the below expressions,

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

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