topic Re: Set Analysis How to select all records with data field criteria ? in QlikView

Set Analysis How to select all records with data field criteria ?

Wed, 16 Jul 2014 18:51:17 GMT

Hi all,

i am new to qlikview and set analysis.

I have column called Key in the Table,

which has below data value.

key

I want to select records where Key = 4 on the line chart irrespective of selection.

How we can do this in set analysis ?

Wed, 16 Jul 2014 18:57:02 GMT

What kind of calculation are you trying to do? You can do something like:

=sum({1<Key = {4}>}field2)

Wed, 16 Jul 2014 19:11:15 GMT

building off Robert's example, this should allow you to select records where key = 4, but irrespective of any selections:

=sum({1<Key = {4}>}field2)

Wed, 16 Jul 2014 19:50:52 GMT

thanks.

let say , i want to put two fields with And criteria,

what would be the syntax ?

let say

Key = 4 AND Report Month = Jan 2014

how we can put in set expression ?

eduardo_sommer — Wed, 16 Jul 2014 19:55:21 GMT

=sum({1<Key={4}, [Report Month]={'Jan 2014'}>} field2)

Eduardo

MK_QSL — Wed, 16 Jul 2014 20:30:54 GMT

You want the Month selection Static or Dynamic?

Consider that you have Month Field as 'MMM YYYY' and want to have dynamic solution, use below

SUM({1<Key = {4}, Month = {'$(=Date(Max(DateField),'MMM YYYY'))'}>}Sales)