topic expression that only allows certain field selections to affect it in QlikView

expression that only allows certain field selections to affect it

matthewp — Fri, 23 Sep 2016 08:19:12 GMT

I have an expression:

SUM({1<sg.yearmonth= $:: sg.yearmonth>}sg.cost)

This makes it so the only selections that can affect the results are from the sg.yearmonth list box.

I would like to add to that sg.year as well

Re: expression that only allows certain field selections to affect it

sunny_talwar — Fri, 23 Sep 2016 08:26:36 GMT

May be this:

Sum({1<sg.yearmonth= $:: sg.yearmonth, sg.year = $::sg.year>} sg.cost)

Re: expression that only allows certain field selections to affect it

adamdavi3s — Fri, 23 Sep 2016 08:26:47 GMT

IS it not just

SUM({1<sg.yearmonth= $:: sg.yearmonth,sg.year>}sg.cost)

I've not used to the $:: notation but simply separating with a comma is the usual way for adding things to set

Re: expression that only allows certain field selections to affect it

adamdavi3s — Fri, 23 Sep 2016 08:27:09 GMT

Sunny what does the $:: notation do?

Re: expression that only allows certain field selections to affect it

miguelbraga — Fri, 23 Sep 2016 08:27:15 GMT

Hey there,

Try this:

=SUM({1<sg.yearmonth= $:: sg.yearmonth, sg.year= $:: sg.year>}sg.cost)

If that doesn't work, please send us a QVW sample or data sample and a further explanation...

Best regards,

D.A. MB

Re: expression that only allows certain field selections to affect it

sunny_talwar — Fri, 23 Sep 2016 08:28:14 GMT

Adam without $:: ... You are ignoring the selection in those fields (which is currently getting handled by 1). This is doing the exact opposite of that. ignore selection in everything except sg.yearmonth and sg.year

Re: expression that only allows certain field selections to affect it

matthewp — Fri, 23 Sep 2016 08:29:49 GMT

Almost perfect Sunny

Just missed the '='

Sum({1<sg.yearmonth= $:: sg.yearmonth, sg.year= $:: sg.year>} sg.cost)

Re: expression that only allows certain field selections to affect it

adamdavi3s — Fri, 23 Sep 2016 08:31:13 GMT

Hi Sunny,

Cool, so its just a fixed notation to be aware of then

somefield = $:: somefield

Handy to know thank you.

Re: expression that only allows certain field selections to affect it

sunny_talwar — Fri, 23 Sep 2016 08:33:44 GMT

Its added now

Re: expression that only allows certain field selections to affect it

sunny_talwar — Fri, 23 Sep 2016 08:34:02 GMT

Yup, you got it