topic Re: Set analysis question in QlikView

Set analysis question

Tue, 07 Oct 2014 16:52:08 GMT

Hi I was wondering ..usually while using set analysis when we have something like sum{<region={'America'}>}Amount it just sums the amount where region = america,

But I have seen many places people using something like

sum{<Region=>A}amount

what does that signify?

what does field name = blank signify in set analysis and what are its uses?

Thanks for your help

Re: Set analysis question

Tue, 07 Oct 2014 16:53:24 GMT

Hi,

sum{<Region=>A}amount

means ignore all selections made within region. So if you had America selected the sum would still return you the total of amount for all regions

Joe

Re: Set analysis question

maxgro — Tue, 07 Oct 2014 16:59:33 GMT

sum( {$<Region = >} amount)

sum( {$<Region=>} amount)

returns the amount for the current selection, but with the selection in “Region” removed;

the amount returned doesn't depends on user selection on Region field

Re: Set analysis question

stevedark — Tue, 07 Oct 2014 17:02:06 GMT

As Joe says, Region= is ignore selections in that field. It's worth knowing some of the other options though.

For example:

sum({<Region={"*"}>}Value) // All non null regions

sum(Region-={'America'}>}Value) // All regions that are not America

sum(Region-={"*"}>}Value) // All regions that are null (not populated)

The Set Identifier is also important, eg.

sum({$<Region=>}Value) // Use current selections, but ignore Region

sum({1<Region={'America'}>}Value) // Ignore all selections, but fix Region to America

sum({1<Region=P({$}Region)>}Value) // Ignore all selections except in Region

The default set identifier is $ (use current selection), so this can be omitted as in your example.

There is lots of fun to be had with Set Analysis, and plenty of documentation on line regarding it.

Hope that helps,

Steve

Re: Set analysis question

Tue, 07 Oct 2014 17:04:54 GMT

ty this was very useful

Re: Set analysis question

ashfaq_haseeb — Tue, 07 Oct 2014 17:24:01 GMT

Hi,

Check this It will help you a lot

Romancing with Set Analysis

Regards

ASHFAQ