calculate relative value dependent on 2 differ column values

[#1]

Hi,

*** I am using Qlik sense desktop. I am not ble to put this question in qlik sense forum.

I have the data set is like below:

Product	Property1	Property2	value	Relative value to a
a	p1	p2	10	1
b	p1	p2	11	1.1
c	p1	p2	10	1
d	p1	p2	12	1.2
a	pp1	pp2	400	1
b	pp1	pp2	425	1.0625
c	pp1	pp2	420	1.05
d	pp1	pp2	444	1.11
a	ppp1	ppp2	22	1
b	ppp1	ppp2	22	1
c	ppp1	ppp2	22	1
d	ppp1	ppp2	22	1
a	pppp1	pppp2	50	1
b	pppp1	pppp2	56	1.12
c	pppp1	pppp2	57	1.14
d	pppp1	pppp2	58	1.16

I calculated the relative value to a column, as value/ value of a(combination of property and property 2 ). And i want to calculate the relative value i have to select from the product filter. So if I select b, i should get all the values in the graph when a product is selected.

I am expecting a grapp like attached pic.

Juthika

[Gysbert_Wassenaar]

You can use this expression as a measure in a table object with Product, Property1 and Property2 as dimensions:

sum({<Product>}value)/sum({<Product={'$(=only(Product))'}>}total <Property1,Property2> value)