topic Re: Creating Set Analysis expression in QlikView

Creating Set Analysis expression

Wed, 03 Jul 2013 10:16:31 GMT

Hi,

iam unable to create the set analysis expression for this

1) Sum of all sales where office=4 and CategoryName is Babywear.

2) Sum of all sales where office=4 and CategoryName is children's wear

please help me out for this expression.

Thanks,

Sudha Banakar

narender123 — Wed, 03 Jul 2013 10:22:19 GMT

=sum({<office={'4'},CategoryName={'Babywear'}>}sales)

=sum({<office={'4'},CategoryName={'children's wear'}>}sales)

Thanks

Narender

Wed, 03 Jul 2013 10:24:35 GMT

Hi,

For me :

=sum({<office={'4'}*{CategoryName={'Babywear'}>}Sales)

=sum({<office={'4'}*{CategoryName={'children'&chr(39)&'s wear'}>}Sales)

Regard

RedSky001 — Wed, 03 Jul 2013 10:28:32 GMT

sum({$<office={'4'},CategoryName={'Babywear'}>} sales )

sum({$<CategoryName={"children's wear"}>} sales )

Wed, 03 Jul 2013 10:29:20 GMT

=sum({<office={'4'},CategoryName={'Babywear'}>}sales)

=sum({<office={'4'},CategoryName={'children's wear'}>}sales)

Wed, 03 Jul 2013 12:30:25 GMT

Hi,

Thank u soo much for your guide..

But iam not able to add dimension and expression for this to create a line chart..

x-axis of the line chart must show year date

y-axis of the line chart must show sales

please help me out..

Thanks

Sudha Banakar

rajeshvaswani77 — Wed, 03 Jul 2013 12:37:48 GMT

Add YearMonth in X-Axis and Add the above two expressions for Y-Axis.

thanks,

Rajesh Vaswani