topic Re: set anlysiswith dimension in QlikView

set anlysiswith dimension

souadouert — Tue, 24 Apr 2018 13:20:43 GMT

Hello,

I need to use the set analysis with one dimension,

if (total in 2017> total in2018, yes, no)

Re: set anlysiswith dimension

sunny_talwar — Tue, 24 Apr 2018 13:24:07 GMT

What is the dimension and what is the expression?

Re: set anlysiswith dimension

souadouert — Tue, 24 Apr 2018 13:30:10 GMT

I have many clients and i need to calcult total sales for each client and i need to add a flag {yes , no}

if( total sales in 2018 < total sales in 2017, yes ,no)

Re: set anlysiswith dimension

sunny_talwar — Tue, 24 Apr 2018 13:31:07 GMT

In the script or in the chart?

Re: set anlysiswith dimension

souadouert — Tue, 24 Apr 2018 13:31:47 GMT

dimesion in chart

Re: set anlysiswith dimension

sunny_talwar — Tue, 24 Apr 2018 13:34:16 GMT

So, you have client as one dimension and you want to add the second one as yes or no?

Re: set anlysiswith dimension

souadouert — Tue, 24 Apr 2018 13:44:29 GMT

yes sunny

Re: set anlysiswith dimension

sunny_talwar — Tue, 24 Apr 2018 13:46:25 GMT

May be like this

Aggr(If(Sum({<Year = {2018}>}Sales) < Sum({<Year = {2017}>}Sales), 'Yes', 'No'), Client)

Re: set anlysiswith dimension

souadouert — Tue, 24 Apr 2018 13:49:41 GMT

and if I have the total prepared in the script ?

Re: set anlysiswith dimension

sunny_talwar — Tue, 24 Apr 2018 13:50:37 GMT

Then this

Aggr(If(2018Sales < 2017Sales, 'Yes', 'No'), Client)

Re: set anlysiswith dimension

souadouert — Tue, 24 Apr 2018 13:51:54 GMT

Re: set anlysiswith dimension

sunny_talwar — Tue, 24 Apr 2018 13:53:03 GMT

What do I do with this?

Re: set anlysiswith dimension

souadouert — Tue, 24 Apr 2018 13:54:15 GMT

so in this case i need this ?

Aggr(If(({<YEAR={'2018'}>}Sales)< ({<YEAR={'2017'}>}Sales), 'Yes', 'No'), Client)

Re: set anlysiswith dimension

sunny_talwar — Tue, 24 Apr 2018 13:54:57 GMT

You might have missed the Sum()

Aggr(If(Sum({<Year = {2018}>}Sales) < Sum({<Year = {2017}>}Sales), 'Yes', 'No'), Client)

Re: set anlysiswith dimension

sunny_talwar — Tue, 24 Apr 2018 13:55:33 GMT

Or use Only()

Aggr(If(Only({<Year = {2018}>}Sales) < Only({<Year = {2017}>}Sales), 'Yes', 'No'), Client)

Re: set anlysiswith dimension

souadouert — Tue, 24 Apr 2018 14:36:53 GMT

THANK YOU SUNNY