Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All, @sunny_talwar
i have a requirement for a Table in Qliksense.
I have two dimension "Dim1" and "Dim2" and two measures "Measure1" and "Measure2".
Tried with valuelist function, but Dim1 and Dim2 values are dynamic.
Measure2 is calculated based on aggr of Dim1 & Dim2.
Ex:- For 'A' = (23/(25+40) )*100 = 38%
For 'x' = (10/(10+5) )*100 = 67%.
How to achieve this scenario. Please someone help me on this.
Thanks & Regards,
How are you getting 23 in the numerator for A? Is it a typo? Also, Measure 1 is a field or is an expression?
Sorry, its a typo. Measure 1 is a expression.
it would be easy to help if you would share a sample where we can see the measure and all other things.