topic Re: How does Conditional option in expression tab works? QV11 in QlikView

How does Conditional option in expression tab works? QV11

Hatus — Fri, 08 Jun 2012 13:04:14 GMT

Hello Everyone

I am new in QV11 and have a simple question, How does the Conditional option in expression tab works?

Thank you for your advices

Sokkorn — Sat, 09 Jun 2012 02:33:47 GMT

Hi BR,

The Conditional in expression will enable or disable your expression while it meet certain criteria. Check more in the attached file.

Regards,

Sokkorn

Hatus — Thu, 14 Jun 2012 10:26:00 GMT

Thanks for the advice. Can you use the Expression Calculation Condition to manipulate the calculation order?

Like:

Expression_1

sum(Sales)

//no Contidions

Expression_2

sum(costs)

Condition: Expression_1>0

Or Condition: Column(1) >0

That would help me to create a Chart with very complex Expressions. The condition should not recalculate the Expression_1 again

Like:

Expression_2

sum(costs)

Condition: sum(sales)>0

Oderwise it will crash.

Thank you

vikasmahajan — Sun, 05 Jan 2014 11:32:11 GMT

Sokkam

I Have users and there respective divisions , I want to send email using macros presently

I am sending but now I want to send mail to user with his receptive division through qlikview

Whether can this possible ?

Vikas

Clever_Anjos — Sun, 05 Jan 2014 12:33:30 GMT

Any expression that returns 0 will disable the expression. Any other value will enable it