topic Re: Set analysis - allow only one field to change expression result in QlikView

Set analysis - allow only one field to change expression result

Fri, 02 May 2014 12:10:08 GMT

I know how to use $ and 1 in set analysis. But how do I make it so that only certain fields can alter the calculation. i.e. If the user selects Region, the value changes, but if they select Product it doesn't.

Re: Set analysis - allow only one field to change expression result

sudeepkm — Fri, 02 May 2014 12:12:40 GMT

You may use like below. Below expression will ignore the value of Product selected.

sum({<Product= >} SalesAmount)

Re: Set analysis - allow only one field to change expression result

swuehl — Fri, 02 May 2014 12:13:05 GMT

Maybe like

=sum({1<Region = $::Region>} VALUE)

Re: Set analysis - allow only one field to change expression result

its_anandrjs — Fri, 02 May 2014 12:18:03 GMT

By pass your selection or ignore the selection like

Sum({<Year=,Month=,Product= >} Value)

Re: Set analysis - allow only one field to change expression result

Fri, 02 May 2014 12:24:19 GMT

Is it possible to do the inverse? So instead of telling it what fields to ignore, tell it what fields to not ignore?

Re: Set analysis - allow only one field to change expression result

sudeepkm — Fri, 02 May 2014 12:26:15 GMT

please see Swuehl's answer. sum({1<Region = $::Region>} VALUE)

Re: Set analysis - allow only one field to change expression result

Fri, 02 May 2014 13:35:55 GMT

you can try this:

sum({1<REGION = {$(=GetFieldSelections(REGION))}> sales}

This will alter the calculation only if one or several regions are selected.

Re: Set analysis - allow only one field to change expression result

lukaspuschner — Fri, 02 May 2014 14:11:28 GMT

you could use alternate states