topic Help need - set analysis in QlikView

Help need - set analysis

Tue, 14 Jun 2011 07:29:05 GMT

Dear all,

I have table table with companyid and salesamount fields.

companyids like 1,2,3,4,5,6

if i select one companyid like 1, the remaining companyids are excluded.

but i dont know how to show the excluded values in the text object.

i have two text objects. one is for current selection and another one is for companyid 2.

if i select 1 then sum(sales) for companyid 2 shows 0.

could anyone help me...

Help need - set analysis

Tue, 14 Jun 2011 07:55:19 GMT

Hi,

Try Sum({$<companyid={2}, companyid=>} sales) in the second text object. This will now not be affected of choices between company id…

/@Ungvall

Help need - set analysis

Tue, 14 Jun 2011 08:02:06 GMT

You can use sum({<companyid={2}>} sales) for the companyid 2

Help need - set analysis

Tue, 14 Jun 2011 08:27:51 GMT

thanks for your reply..

sorry,i missed some of the things..

i have three fields like company id, offsetCompayid,sales

table look like

Compaid offsetcompid sales

1 2 1000

2 3 1900

3 1 2000

etc

if i select the compid 1 then i need to show the sum(sales) for Compid 1 and offsetid =1.

similarly if i select compid 2 then i need to show the sum for Compid 2 and offsetid =2. in two text objects.

could you please help me...

thanks in advance..

Help need - set analysis

Tue, 14 Jun 2011 08:37:26 GMT

Hi,
If I understand you right...

Text object 1 Companyid:

Sum(sales)

Text object 2 Offsetid:

Sum(If(Compid=offsetcompid, sales))

/@Ungvall

Help need - set analysis

Tue, 14 Jun 2011 08:43:39 GMT

Its not working in my case...

could you please share the sample file..

the output look like

in straight table

Compaid sum(offsetcompid=compid)Sales) sales

1 2000 1000

2 1000 1900

3 1900 2000

Re: Help need - set analysis

dpietersz — Tue, 14 Jun 2011 08:49:31 GMT

I would do it with 2 sum expressions in combination with the concat function (so you can select multiple compaid's).

I've attached a example.

Hope this is what you are looking for.