topic Set Analisys condition with table field in QlikView

Set Analisys condition with table field

Mon, 26 Jan 2026 18:19:17 GMT

Hi all,

I would like use "set analisys" instead of "if" funcion.

I would like to check another field in same table !!! see "{Date2} "

Example:

Orders:

     LOAD * INLINE [
    Customer,           OrderDate,           Article,       Qty,              Date2
    000001,           20-01-2011,     FFF200,         50,      20-01-2014,
    000002,           21-02-2012,     GGG120,      300,     20-01-2013,
    000003,           22-03-2013,     HHH140,     1200,     20-01-2011,
    000004,           02-02-2014,     RRR120,     1500,     02-02-2014,
    ];

( {$<OrderDate = {'>=$(vData1)<=$(vData2)'} , OrderDate = {Date2} >} [Qta])

Many Thanks in advance

Claudio

Re: Set Analisys condition with table field

MK_QSL — Sun, 23 Feb 2014 19:36:03 GMT

( {$<OrderDate = {'>=$(vData1)<=$(vData2)'} , OrderDate = {'$(=Date2)'} >} [Qta])

Re: Set Analisys condition with table field

agilos_mla — Sun, 23 Feb 2014 19:37:37 GMT

You should add a recno() as OrderID in your table( because the searched dim cannot be used in the boolean expression),

then it will allow to write sthg like

sum({$<OrderDate = {'>=$(vData1)<=$(vData2)'}, OrderID={"=(OrderDate=Date2)"}>} [Qta])

HTH,

Michael

Re: Set Analisys condition with table field

Sun, 23 Feb 2014 20:27:52 GMT

As Michaël Laenen, you need another thirs field to do a boolean expression. Use Customer as this third field.

See a doc I have written on Set Analysis, it can help you:

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

Fabrice

Re: Set Analisys condition with table field

Mon, 24 Feb 2014 13:41:12 GMT

Many thanks at everybody,

Works perfetclty.

@Fabrice

Nice Manual very userful