Set Analysis - Ignoring all selections, except one

[#1]

Hi, I am wondering what the best syntax is in set analysis to 'ignore all selections except...'  I haven't really used {1} much, and initially assumed the <> modifiers would work the same way they do in {$}.  I would just use {$<fieldA=,fieldB=,fieldC=>}, but I have a large number of possible dimensions that I want to ignore, and only use the date that the user selects.  Does anyone know how this can be achieved?  {1<date>}  does not appear to work as desired.  Thank you for anyone that can help.

[erichshiino]

Hi, Nicole

You can get a solution in this post:

http://community.qlik.com/message/1267#1267

You can use a syntax like this:

sum( {1 < Field3 = {$(=getfieldselections ( Field3 ))} >} Sales )

Regards,

Erich

[swuehl · Accepted solution]

I think something like

Sum({1<Date= p(Date) >} value)

should also work.

Regards,

Stefan

[#4]

Thanks for the help.

Sum({1<Date= p(Date) >} value) appears to return the values I need.

I am getting '0' with the getfieldselections function, but I will definately play around with it, I think it will be a good function to know.