Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

calculate relative value dependent on 2 differ column values

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:

ProductProperty1Property2valueRelative value to a
ap1p2101
bp1p2111.1
cp1p2101
dp1p2121.2
app1pp24001
bpp1pp24251.0625
cpp1pp24201.05
dpp1pp24441.11
appp1ppp2221
bppp1ppp2221
cppp1ppp2221
dppp1ppp2221
apppp1pppp2501
bpppp1pppp2561.12
cpppp1pppp2571.14
dpppp1pppp258

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

1 Reply
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)


talk is cheap, supply exceeds demand