Disable and enable expression

[#1]

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.

[sujeetsingh]

Can you post a sample please?

[SunilChauhan]

use cyclic group instead

create cyclic group of two dimesions

in fact you can create cyclic group of expression

[#4]

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.

[#5]

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

[Joseph_Musekura]

Dear Sir,

See attached sample.

Thanks!

[SunilChauhan]

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

[SunilChauhan]

or if you are not using qv11 the

usin condtion hide  in presentation tab

and use these condition for expressions

hope this helps