topic If condition convert to set analysis in QlikView

If condition convert to set analysis

Fri, 15 Oct 2010 09:41:39 GMT

Hi guys,

Just a simple query. How to convert this if condition into set analysis?

=if(EndTime <= weekstart(Today()) and EndTime >= weekend(Today()), EndTime, Null())

This code is working.. I just want to use its set analysis counterpart (if its possible)

Thanks

If condition convert to set analysis

Anonymous — Fri, 15 Oct 2010 16:16:54 GMT

Something like this?

only({<EndTime = {"<=$(=weekstart(Today()))>=$(=date(weekend(Today())))"}>} EndTime)

If condition convert to set analysis

johnw — Fri, 15 Oct 2010 18:51:55 GMT

null()

In other words, the code you posted will always return null. If your application is working, you did not post the code your application is using. The end time cannot simultaneously be <= the start of the week and >= the end of the week. Since that was probably a typo, go with aby's answer. You'll probably need a date() function around weekstart() too, though.

If condition convert to set analysis

Mon, 18 Oct 2010 07:00:26 GMT

Ops! I pasted the wrong code. Thanks John!.