Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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.

7 Replies
sujeetsingh
Honored Contributor III

Re: Disable and enable expression

Can you post a sample please?

chauhans85
Esteemed Contributor

Re: Disable and enable expression

use cyclic group instead

create cyclic group of two dimesions

in fact you can create cyclic group of expression

Not applicable

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.

Not applicable

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

Employee
Employee

Re: Disable and enable expression

Dear Sir,

See attached sample.

Thanks!

chauhans85
Esteemed Contributor

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

chauhans85
Esteemed Contributor

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

Community Browser