topic HAving error in following script !! in QlikView

HAving error in following script !!

nikhilgarg — Wed, 10 Dec 2014 05:55:49 GMT

HEy,

I am having error in following script:

=Sum({<Event = {'Server_DOWN'} and Type = 'Planned'}>}Duration)

Please help.

thanks

jonathandienst — Wed, 10 Dec 2014 05:57:51 GMT

Assuming this is an expression and not a line of script:

=Sum({<Event = {'Server_DOWN'}, Type = {'Planned'}>} Duration)

HTH

Jonathan

nikhilgarg — Wed, 10 Dec 2014 06:28:19 GMT

HEy,

But why didn't 'and' works instead of ',' ??

Thanks

anbu1984 — Wed, 10 Dec 2014 06:36:45 GMT

And is not available in Set analysis