topic Re: Set Analysis Greater than less than a Variable in QlikView

Set Analysis Greater than less than a Variable

gwenngannon — Tue, 18 Oct 2016 20:11:34 GMT

Hi, I'm trying to use the following but am not getting a result: I've seen many posts on variables, greater than and equal to and have seen a few different iterations: this is what I ended up with and it is not working.

Any ideas on what part of the expression is incorrect

Please

=SUM({< EFF_DATE ={"<=$(=vMaxTransactionDate)"} , EFF_DATE = {">=$(=vMinTransactionDate)"} ,
[TXN_AMOUNT] = {">=$(=vTXNSum)"} >} TXN_AMOUNT)

Re: Set Analysis Greater than less than a Variable

sunny_talwar — Tue, 18 Oct 2016 20:32:12 GMT

May be try like this:

=Sum({<EFF_DATE ={"<=$(=vMaxTransactionDate)>=$(=vMinTransactionDate)"}, [TXN_AMOUNT] = {">=$(=vTXNSum)"}>} TXN_AMOUNT)

Re: Set Analysis Greater than less than a Variable

gwenngannon — Tue, 18 Oct 2016 20:40:56 GMT

Thank you, I'm checking on the expression now, I also want to add Fabs in the set analysis but am having troubles with that also- can you assist with that also ?

Sum({<EFF_DATE ={"<=$(=vMaxTransactionDate)>=$(=vMinTransactionDate)"}, [TXN_AMOUNT] =

{"=fabs(TXN_AMOUNT)"} = ">=$(=vTXNSum)"}>} TXN_AMOUNT)

Re: Set Analysis Greater than less than a Variable

sunny_talwar — Tue, 18 Oct 2016 21:03:03 GMT

May be this:

Sum({<EFF_DATE ={"<=$(=vMaxTransactionDate)>=$(=vMinTransactionDate)"}, [TXN_AMOUNT] = {"=fabs(TXN_AMOUNT) >= vTXNSum"}>} TXN_AMOUNT)

Re: Set Analysis Greater than less than a Variable

gwenngannon — Tue, 18 Oct 2016 23:21:15 GMT

Sunny T ,

This is great thank you- I am still having troubles, although I agree this looks correct

when I break the expression up in an if it works but converting to Set analysis does not give me results

I am looking into the possibility of dates HH MM SS not working well in Set Analysis when using variables for Dates without HH MM SS??? not sure if anyone has ever run into this problem

Re: Set Analysis Greater than less than a Variable

sunny_talwar — Wed, 19 Oct 2016 08:45:39 GMT

I am not sure what you have behind those variables, but a good place to start would be here:

Dates in Set Analysis‌

Re: Set Analysis Greater than less than a Variable

gwenngannon — Wed, 19 Oct 2016 15:55:36 GMT

Everything worked perfectly once I adjusted the date format- thanks for your help