topic Re: Expression enable/ disable in QlikView

Expression enable/ disable

Mon, 30 May 2011 11:40:02 GMT

Hi,

I have multiple expressions in my waterall chart.

If I uncheck ENABLE option in chart properties, the right side bar should ignore this particular value in its expression.

If I Check ENABLE option in chart properties, the right side bar should consider this value and calculate accordingly.

HOW CAN I DO THIS HAPPEN.

Expression enable/ disable

Anonymous — Mon, 30 May 2011 13:35:22 GMT

What you can do is make a variable (fe vEnable) and make your button set this variable to 1 or o.

Where 1 Enable and 0 is Disable

Now you can use these variabel in your expression or in your dimension

Re: Expression enable/ disable

Anonymous — Mon, 30 May 2011 13:47:50 GMT

Take a look at the attached file for an example.

Hope it helps.

Re: Expression enable/ disable

Tue, 31 May 2011 05:18:33 GMT

Dennis, thanks a lot.

But, this is not exactly what I was asking about.

Let me put the question clear...

I have 4 expressions in my waterfall chart.

>expr1 = 100

>expr2 = 40

>expr3 = 50

>expr4 = 10 (expr1-expr2-expr3)

now, If I uncheck 'Enable' option in chart properties for exp3 then I expr4 = (expr1-expr2).

If I check 'Enable' option' in the chart properties of the same expr3 then expr4 = (expr1-expr2-expr3).

Now is that possible to calculate expr4 based on the active and inactive status of the expr3?

Re: Expression enable/ disable

Anonymous — Tue, 31 May 2011 06:30:32 GMT

If I understand you correctly you must be able to that as I did in the attached file.

Take a closer look at charts on the right. the expression there is:

If (vEnable=1 , Sum (Amount), Count(Amount))

This make it swicth between the 2 different expression.

So What you need is somthing like:

If (vEnable=1, (expr1-expr2), (expr1-expr2-expr3))

Let me know if this works for you ok?

If not try to upload you document or some screenshots which show how you want the outcome to be.

Re: Expression enable/ disable

Tue, 31 May 2011 06:41:16 GMT

Hey Dennis, thank u again...

Wat u said absolutely works fine...

but thing is I dont need any button for this, it should acquire the properties of expression from the chart and trigger the action accordingly.....

Re: Expression enable/ disable

Tue, 31 May 2011 06:46:44 GMT

i have an example developed for u but dont know how to upload QV file.

Any idea?

Re: Expression enable/ disable

Tue, 31 May 2011 06:49:08 GMT

hi,

i got it how to upload. First add comment then edit the comment u will be able to see Upload file.

Pls look at the above attachment.

Hope it will help you.

Re: Expression enable/ disable

Tue, 31 May 2011 07:11:37 GMT

Hey BlackRocks buddy, thanks a lot....

u really made me to think that this can be done in simple way....

how can i do the same without using the dimesion fields F1, F2?

like IF(Not IsNull(cloumn(2)), 'expr4=(expr1-expr2-expr3)', 'expr4=(expr1-expr2-expr3)')

Does this work this way...

i mean validating 'column(2)'? or is there any btr way i can handle this?

Re: Expression enable/ disable

Tue, 31 May 2011 08:00:42 GMT

hi I really didn't get you in full what you are trying to do.

in my example F1,F2 are Field names I just took for example, you can give any meaningful names to them.

You will not be able to refer column(0), column(1).. etc as you are disabling expressions based on your need.

When you disable any column it wont know that there is one column and it ignores the disabled column and counts sequentially. But in your expression it always refers to 3 columns but in reality there will be only 2 enabled. So this wont work out for your requirement

Re: Expression enable/ disable

Tue, 31 May 2011 08:09:48 GMT

Yes, after submitting the ques i realized it is not possible...m sorry for that...

thing is i dont have exact field which refers to particular expression in my dimensions.

cos the expression is actually declared as a variable. expr3=50 using the same in my expr3 in chart as $(expr)

Now m lukin if it is possible that,

IF((Not IsnNull(<expr3>)), 'expr4=(expr1-expr2-expr3)', 'expr4=(expr1-expr2)') ?

hope you got my ques....

Re: Expression enable/ disable

Tue, 31 May 2011 08:26:49 GMT

No problem.

But i guess if you can post your complete actual requirement with some qvw sample document attached, i can try help you on that.

Re: Expression enable/ disable

Tue, 31 May 2011 08:31:56 GMT

Yes I can do that, but before that please tell me...

if it works to apply condition barely on 'expression' itself wit in the if statement like i explained above?

that way my prob is solved almost....

Re: Expression enable/ disable

Tue, 31 May 2011 08:46:12 GMT

Yes you can do that but differently by using variables as attached sample.

Sample shows using variables only but you need to use those variables to check if it returns anything otherwise use different expression. Basically u need to build the epxression.

Re: Expression enable/ disable

Tue, 31 May 2011 09:48:23 GMT

hey pls find the file below...

now my doubt is

>if I disable 'expr3' in the chart properties by unchecking the 'Enable' option then 'expr4= $(v1)-$(v2)' else 'expr4= $(v1)-$(v2)-$(v3)'

Re: Expression enable/ disable

Tue, 31 May 2011 10:02:54 GMT

Check the attached.

Re: Expression enable/ disable

Tue, 31 May 2011 10:41:20 GMT

Thanks a lot buddy.....

Thing is its not working for my actual application... still working on it.

if i m not able to... will sure update the status...

Re: Expression enable/ disable

Tue, 31 May 2011 12:21:29 GMT

Thanks a lot, and the prob with my application is resolved by renaming the column name......

Thank u so much buddies in helping me out.

Re: Expression enable/ disable

Wed, 01 Jun 2011 01:25:49 GMT

Great finally we could do it.

Expression enable/ disable

Tue, 14 Jun 2011 08:39:31 GMT

Macro VBS to enable/disable expression:

set chart = doc.GetSheetObject("CH01")

set cp = chart.GetProperties

set expr = cp.Expressions.Item(3).Item(0).Data.ExpressionData

expr.Enable = false

chart.SetProperties cp