topic Re: Extract conditions from sheets? in QlikView

Extract conditions from sheets?

Wed, 23 Jul 2014 14:30:16 GMT

Is there a way to extract the show condition of the sheets in an application from a macro?

Thanks

datanibbler — Wed, 23 Jul 2014 14:35:08 GMT

Hi Jonathan,

sure that should be possible if you can read the macro. Could you post or attach it?

Wed, 23 Jul 2014 14:39:19 GMT

Hi DataNibbler,

At the moment, I don't have a macro set up for this. I am trying to find the function that will return these conditions.

gmoraleswit — Wed, 23 Jul 2014 15:14:53 GMT

I found this example in the API:

set mysheet=ActiveDocument.ActiveSheet

set sp=mysheet.GetProperties

sp.Show.Always = false

sp.Show.Expression.v = "sum(Sales)>4000"

mysheet.SetProperties sp

Hope this helps you