7 Replies Latest reply: May 13, 2014 5:49 AM by Sunil Chauhan

# Disable and enable expression

Hi all,

I have 4 fields:

code,

Quantity,

rate,

Value.

I need to show in straight table like for code 1, sum of quantity and for code 2 sum of value.

in this way

:

Code

1     sum of quantity    xyz

2     Sum of Value        ABC .

WHERE xyz and ABC are respective values. Basically I use code as dimension and 2 expressions ie sum of quantity and sum of value

which must be filtered on the basis of valu of dimension. I have attached my file here. please Help.

• ###### Re: Disable and enable expression

Can you post a sample please?

• ###### Re: Disable and enable expression

Sir,

Please Have a look at my attached file.

MY required output should be in this way.

Code

1        Sum of Quantity    1

2         Sum of Value      21.

3        Average Rate        5.

In my files attached to you, you can find out that there are 4 fields code, quantity , value and rate where I used code as dimension and have 3 expressions which must be shown in front end according to value of dimension.

• ###### Re: Disable and enable expression

create cyclic group of two dimesions

in fact you can create cyclic group of expression

• ###### Re: Disable and enable expression

Sir I have only 1 dimension but i need to represent 3 expressions from that 1 dimension.

But I need to show those expression on the basis of the value on the dimension.

suppose for first value of dimension only first expression and

for 2nd value of dimension 2nd expression

• ###### Re: Disable and enable expression

Dear Sir,

See attached sample.

Thanks!

• ###### Re: Disable and enable expression

in qv 11 you have a option of enable dimension and express using condition

you can write all three expression

and on each expression write like below

in Condition of expression

Code=1 for expression

code=2 for expression

code =3 for expression 3

hope this helps

• ###### Re: Disable and enable expression

or if you are not using qv11 the

usin condtion hide  in presentation tab

and use these condition for expressions

hope this helps