topic Re: Disable and enable expression in QlikView

Disable and enable expression

Tue, 13 May 2014 09:17:18 GMT

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

sujeetsingh — Tue, 13 May 2014 09:21:02 GMT

Can you post a sample please?

Re: Disable and enable expression

SunilChauhan — Tue, 13 May 2014 09:22:05 GMT

use cyclic group instead

create cyclic group of two dimesions

in fact you can create cyclic group of expression

Re: Disable and enable expression

Tue, 13 May 2014 09:28:06 GMT

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

Tue, 13 May 2014 09:33:54 GMT

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

Joseph_Musekura — Tue, 13 May 2014 09:41:37 GMT

Dear Sir,

See attached sample.

Thanks!

Re: Disable and enable expression

SunilChauhan — Tue, 13 May 2014 09:47:48 GMT

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

SunilChauhan — Tue, 13 May 2014 09:49:00 GMT

or if you are not using qv11 the

usin condtion hide in presentation tab

and use these condition for expressions

hope this helps