topic Set Analysis - Ignoring all selections, except one in QlikView

Set Analysis - Ignoring all selections, except one

Tue, 16 Aug 2011 16:20:58 GMT

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.

Set Analysis - Ignoring all selections, except one

erichshiino — Tue, 16 Aug 2011 16:30:11 GMT

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

Set Analysis - Ignoring all selections, except one

swuehl — Tue, 16 Aug 2011 16:35:05 GMT

I think something like

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

should also work.

Regards,

Stefan

Set Analysis - Ignoring all selections, except one

Tue, 16 Aug 2011 16:59:22 GMT

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.