topic Re: Set Analysis in QlikView

Set Analysis

MK_QSL — Thu, 26 Jun 2014 10:50:33 GMT

Using below set expression, I am getting the correct result...

Just want to know, is there any merged/shorter version of this expression possible?

=SUM({<Brand = {'B1','B2'}, Type = {1}>}Sales)

SUM({<Brand = {'B3'}, Type = {3}>}Sales)

SUM({<Brand = {'B4'}, Type = {2}>}Sales)

Thu, 26 Jun 2014 10:56:14 GMT

Hi,

U can try this one

=Sum( {<Brand = {'B1','B2'}, Type = {1}> + <Brand = {'B3'}, Type = {3}>+<Brand = {'B4'}, Type = {2}> } Sales)

Regards,

Vivek

kalyandg — Thu, 26 Jun 2014 10:56:33 GMT

hi Manish,

you can try this

=sum({<Brand={'B1', 'B2', 'B3', 'B4'}, Type={'1','2','3'}>}sales)

Best Regards,

Kalyan.D

tresB — Thu, 26 Jun 2014 10:56:42 GMT

This?

=SUM({<Brand = {'B1','B2'}, Type = {1}> + <Brand = {'B3'}, Type = {3}> + <Brand = {'B4'}, Type = {2}>}Sales)

MK_QSL — Thu, 26 Jun 2014 11:05:31 GMT

So Simple... How come I haven't think about it?

MK_QSL — Thu, 26 Jun 2014 11:09:43 GMT

What if ?

=SUM({<Country = {'UK'}, Brand = {'B1','B2'}, Type = {1}>}Sales)

SUM({<Country = {'UK'}, Brand = {'B3'}, Type = {3}>}Sales)

SUM({<Country = {'UK'}, Brand = {'B4'}, Type = {2}>}Sales)

Question is Can we make Country = {'UK'} common or need to mention everywhere

tresB — Thu, 26 Jun 2014 11:25:39 GMT

May be this?

=SUM({<Country = {'UK'}>* (<Brand = {'B1','B2'}, Type = {1}>+ <Brand = {'B3'}, Type = {3}>+< Brand = {'B4'}, Type = {2}>)>} Sales)

MK_QSL — Thu, 26 Jun 2014 11:44:07 GMT

Giving syntax error!

tresB — Thu, 26 Jun 2014 12:15:14 GMT

This?

=SUM({<Country = {'UK'}>* (<Brand = {'B1','B2'}, Type = {1}>+ <Brand = {'B3'}, Type = {3}>+< Brand = {'B4'}, Type = {2}>)} Sales)

Removed an extra '>'