topic Set to return a value from a table in QlikView

Set to return a value from a table

Thu, 05 Jun 2014 03:35:42 GMT

QV Gurus, one and all

I have been stumped on this one for quite a while.

I have a table which has four headings...Area, MinPt, MaxPt, DaysHence

I need to develop a set that returns the value in DaysHence, where the result of a forumla within the same table (let's call it TP) is greater than MinP and less than MaxP

I have tried combinations of the following with max, Only, Sum, Min etc, but to no avail.

=sum({<MinPt = {"<=[TP]"},MaxPt = {"<=[TP]"}>}DaysHence)

I believe the problem will lie with the use of the Field name [TP]...would anyone know a way around it?

The forumula that creates [TP] is a combination nested if/set evaluation using two programmable variables, so i donlt know if it can be included in it's raw form

Thanks in advance

Rick Green

Re: Set to return a value from a table

anbu1984 — Thu, 05 Jun 2014 05:12:28 GMT

=sum({<MinPt = {"<=[TP]"},MaxPt = {">=[TP]"}>}DaysHence)

Re: Set to return a value from a table

sujeetsingh — Thu, 05 Jun 2014 05:57:21 GMT

Rick,

As per my level of thinking i will define this new field in script with checking nested iff conditions.

Just do it and iff needed then provide a sample

Re: Set to return a value from a table

Thu, 12 Jun 2014 10:54:51 GMT

Thank you all for your help. In the end I created a new table in excel with all the possible values (value will never go over 2000) and have referenced that directly, rather than try the greater than and equal to approach.