topic Re: need help with expression in QlikView

need help with expression

Sun, 20 Jul 2014 08:45:42 GMT

hi,

I am using pivot table,I need expression for

total of month real value/total of years real value and where measure is kg I need

total of month value/product's equal value under real

in one expression

product	qty	real	measure	month	year
apple	1	2	kg	apr	2010
mango	1	4	kg	apr	2010
headphone	1	8	piece	apr	2010
milk	1	9	ltr	apr	2010
equal	1	45		apr	2010
apple	1	3	kg	may	2010
mango	1	5	kg	may	2010
headphone	1	6	piece	may	2010
milk	1	8	ltr	may	2010
equal	1	93		may	2010
apple	1	2	kg	jan	2011
mango	1	6	kg	jan	2011
headphone	1	7	piece	jan	2011
milk	1	8	ltr	jan	2011
equal	1	87		jan	2011

MK_QSL — Sun, 20 Jul 2014 08:53:12 GMT

Uncelar from your question what exactly you want... Can you provide the result you are looking for...? Thanks

Sun, 20 Jul 2014 09:05:29 GMT

hi,

I jus need the expression
for

total of months real(column) value/total of years real(column) value and if measure is kg then I want

total of months real(column) value/Products column equal's value under real.

for eg

total of apr months real value is 68 and total of 2010 real's value is 183

so I want 68/183 and in case if measue is kg then I want

68/products column equals value under real column.

==products column equal value under real for month apr is 45 for may it is 93 and for jan its 87

so I want 68 /45 for apr
and likewise if measure id kg

this thing in one expression

avinashelite — Sun, 20 Jul 2014 10:16:26 GMT

Can you please share the app.

lironbaram — Sun, 20 Jul 2014 10:22:41 GMT

have a look at the attach example

hope it helps you