Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Tags (1)
1 Reply

Re: calculate relative value dependent on 2 differ column values

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
Community Browser