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

[#1]

Hi all,

i am new to qlikview and set analysis.

I have column called Key in the Table,

which has below data value.

key

1

2

3

4

5

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

How we can do this in set analysis ?

[#2]

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

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

[#3]

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)

[#4]

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]

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

Eduardo

[MK_QSL]

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)