Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Extract conditions from sheets?

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

Thanks

1 Solution

Accepted Solutions
gmoraleswit
Contributor II

Re: Extract conditions from sheets?

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

3 Replies
datanibbler
Esteemed Contributor

Re: Extract conditions from sheets?

Hi Jonathan,

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

Not applicable

Re: Extract conditions from sheets?

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
Contributor II

Re: Extract conditions from sheets?

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

Community Browser