topic Re: difference between two sets in QlikView

difference between two sets

Wed, 04 Sep 2013 13:23:01 GMT

I have the following table:

Group	location	cost	person
1	IL	324	james
1	IL	2342	cath
2	IL	234	any
2	IL	234	ben
3	CA	244	dur

Using set analysis I have calculated the total cost per location and I am displaying this in a straight table.

If I now want to show the total cost per location per group for two groups at a time, how do I do it?

also how do I find the difference between the groups?

Thanks

Re: difference between two sets

swuehl — Wed, 04 Sep 2013 13:46:47 GMT

I assume above explains your data model table.

It's quite unclear to me why you are using set analysis to show a total per location - it should be sufficient to just group by location (i.e. use location as dimension).

It's probably better if you can post a small sample app together with your expected outcome.

Re: difference between two sets

Wed, 04 Sep 2013 13:56:18 GMT

try unsing a sum or pivot table with the

- dimensions Group and Location

- expression "sum(costs)"