topic Re: set analysis in QlikView

set analysis

Mon, 07 Oct 2013 06:14:14 GMT

i am using if condition to display field on basis of reload time as if(time(reloadtime()>=' xyx' and time(relaodtime())=<'abc' and date(reloadtime())=date(today()),concat(field)) . but more than 2 and condition is not working. is there any way to display field on basis of above reload time.

Re: set analysis

tresB — Mon, 07 Oct 2013 06:27:08 GMT

Without going to alternative. I can tell you that there is no such restriction in use of number of ANDs. If placed properly, it should work fine.

try like:

If( Time(ReloadTime())>=' xyz' AND Time(ReloadTime())<'abc' AND Date(ReloadTime())=Date(Today()) , Concat(field))

Re: set analysis

Mon, 07 Oct 2013 06:30:08 GMT

Hi Piyush,

Try this if(time(reloadtime()>=' xyx', if(time(relaodtime())=<'abc',if(date(reloadtime())=date(today()),concat(field)))))

What I mean is..try putting it in loops,multiple AND conditions might not work in your case.

Hope this Helps,

Please get back to me with your result,if possible share your qvw.

Thanks,

Rochelle

Re: set analysis

Mon, 07 Oct 2013 06:32:39 GMT

hi, try like this

if(time((reloadtime()>=' xyx') and( time(relaodtime())=<'abc') and (date(reloadtime()))=date(today()),concat(field))

wrap each AND in extra parentheses.

Re: set analysis

Mon, 07 Oct 2013 06:52:36 GMT

thanks for your suggestion but still its not working.

Re: set analysis

Mon, 07 Oct 2013 06:53:23 GMT

thanx john, i have tried the above option but still its not working.

Re: set analysis

Mon, 07 Oct 2013 06:54:09 GMT

hi, treseco

i hav tried but its not working

Re: set analysis

tresB — Mon, 07 Oct 2013 06:57:56 GMT

Can you please share your sample app?

Re: set analysis

Mon, 07 Oct 2013 07:53:16 GMT

means a problem in calculation instead of the syntax.

join tresesco, lay out the project