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: 
abhijith28
Creator II
Creator II

Multiple Dimension in single column with dynamic values in a table.

Hi All, @sunny_talwar 

i have a requirement for a Table in Qliksense.

abhijith28_0-1596786734828.png

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,

 

 

 

 

Labels (1)
3 Replies
sunny_talwar

How are you getting 23 in the numerator for A? Is it a typo? Also, Measure 1 is a field or is an expression?

abhijith28
Creator II
Creator II
Author

Hi @sunny_talwar 

Sorry, its a typo. Measure 1 is a expression.

sunny_talwar

it would be easy to help if you would share a sample where we can see the measure and all other things.