Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
I think something like
Sum({1<Date= p(Date) >} value)
should also work.
Regards,
Stefan
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
I think something like
Sum({1<Date= p(Date) >} value)
should also work.
Regards,
Stefan
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.