topic Re: Set Analysis combined with getfieldselections in QlikView

Set Analysis combined with getfieldselections

Thu, 06 Feb 2014 10:26:42 GMT

Hi all,

I am trying to create an expression that contains set analysis and combines it with getfieldselections() function.

I have tried :

sum({<TransactionDay={'=$(=(GetFieldSelections(SnapshotDay)))'}>}movement_quantity)

sum({<TransactionDay={'=$(#GetFieldSelections(SnapshotDay))'}>}movement_quantity)

as well as others. I am trying to implement that instead of a trigger in a field to correlate selections.

Is that possible??

Regards,

Re: Set Analysis combined with getfieldselections

giakoum — Thu, 06 Feb 2014 10:33:04 GMT

Nikos, try putting the getfieldselections function into a variable

Re: Set Analysis combined with getfieldselections

Thu, 06 Feb 2014 10:42:41 GMT

Hi Gianni,

I have tried

set vSyncTransactSnapshot=GetFieldSelections(SnapshotDay);

sum({<TransactionDay={'=$(#vSyncTransactSnapshot)'}>}movement_quantity)

this as well but it does not seem to work properly.

Regards

Re: Set Analysis combined with getfieldselections

giakoum — Thu, 06 Feb 2014 10:45:19 GMT

try without the # :

sum({<TransactionDay={'=$(=vSyncTransactSnapshot)'}>}movement_quantity)

sum({<TransactionDay={'=$(vSyncTransactSnapshot)'}>}movement_quantity)

Re: Set Analysis combined with getfieldselections

Thu, 06 Feb 2014 13:44:15 GMT

Hi Giannis,

No luck yet.

I think I am going to try the trigger field selection

Regards

Re: Set Analysis combined with getfieldselections

jerem1234 — Thu, 06 Feb 2014 14:50:49 GMT

Try the concat function instead:

=sum({<TransactionDay={$(=concat(distinct chr(39) & SnapshotDay & chr(39), ','))}>}movement_quantity)

This has the added advantage where you don't have to specify the number of elements at which GetFieldSelections changes to a format like '12 out of 54'.

If you insist on GetFieldSelections or need it to get specifically the values selected, use:

=sum({<TransactionDay={'$(=GetFieldSelections(SnapshotDay,chr(39) &',' & chr(39), 100))'}>}movement_quantity)

where 100 is just a large number to prevent it to from changing the string to above or "NOT ...".

Hope this helps!

Re: Set Analysis combined with getfieldselections

Anonymous — Thu, 06 Feb 2014 14:54:57 GMT

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

Re: Set Analysis combined with getfieldselections

Anonymous — Thu, 06 Feb 2014 14:57:09 GMT

But my preference is to use P():
sum({<TransactionDay=P(SnapshotDay)>} movement_quantity)

It works even if no selections made, and no need to additional parameters.

Re: Set Analysis combined with getfieldselections

Thu, 06 Feb 2014 15:14:40 GMT

That is a superb solution jerem1234.

Thank you very much.

Re: Set Analysis combined with getfieldselections

Thu, 06 Feb 2014 15:28:57 GMT

Thanks for the help Michael your solution is way more elegant, thus I will mark this one as correct.