topic Ignore all except some fields Set Analysis in QlikView

Ignore all except some fields Set Analysis

eleni_theodorid — Fri, 20 Sep 2013 07:42:21 GMT

Hi All,

I need help with a Set Analysis. I want to calculate Sales ignoring all the selected values in all fields except of 3 fields.

I have a lot of fields to ignore and it's really meaningless to ignore them one by one in the Set Analysis. I think that I need something like that

sum({1<Field1={"$(=getfieldselections(Field1))"}, Field2={"$(=getfieldselections(Field2))"}, Field3={"$(=getfieldselections(Field3))"}>} Sales)

but it doesn't work if there are no selections in all my 3 fields (and I want it to work like qlikview, at the clear state to caught all the values, not none of them). Any ideas?

Thanks in advance,

Helen

Re: Ignore all except some fields Set Analysis

Fri, 20 Sep 2013 08:08:41 GMT

Hi Helen,

You can add this in the set analysis part of your expression:

$(=Concat({1<$Field -= {'Field1','Field2'}>} distinct '[' & $Field & ']=',','))

This will ignore all fields except Field1 and Field2 (add as many as you want).

Check this out too:

http://community.qlik.com/docs/DOC-1334

Hope this helps.

Re: Ignore all except some fields Set Analysis

eleni_theodorid — Fri, 20 Sep 2013 08:28:09 GMT

Hi Jean-Pierre,

You save my day!

I couldn't found this discussion while i was looking for this! It works for me perfectly.

Thank you very much!