Discussion Board for collaboration on QlikView Scripting.
I have 4 fields:
I need to show in straight table like for code 1, sum of quantity and for code 2 sum of value.
in this way
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.
Can you post a sample please?
use cyclic group instead
create cyclic group of two dimesions
in fact you can create cyclic group of expression
Please Have a look at my attached file.
MY required output should be in this way.
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.
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
See attached sample.
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
or if you are not using qv11 the
usin condtion hide in presentation tab
and use these condition for expressions
hope this helps