Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Set Analysis - Ignoring all selections, except one

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.

1 Solution

Accepted Solutions
MVP
MVP

Set Analysis - Ignoring all selections, except one

I think something like

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

should also work.

Regards,

Stefan

3 Replies
erich_shiino
Honored Contributor

Set Analysis - Ignoring all selections, except one

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

MVP
MVP

Set Analysis - Ignoring all selections, except one

I think something like

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

should also work.

Regards,

Stefan

Not applicable

Set Analysis - Ignoring all selections, except one

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.

Community Browser