Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
jjustingkm
Creator
Creator

Measure Calculation should change dynamically

i have a table like below.

 

VALUE   METRIC

C            COUNT(ID)

A            AVG(NUM)

Then a chart that change based on expression,  if 'A' is selected that measure should be Avg(num), I give metric in the measure value in the chart but it is displaying as 'Avg(num)'.

 

Thanks,

Labels (1)
1 Reply
jwjackso
Specialist III
Specialist III

Using this data.

Metric:
load * Inline [
Value,Metric
C,Count(ID)
A,AVG(NUM)
];

Data:
Load * Inline [
ID,NUM
1,100
1,200
2,200
3,300
];

If 'A' is selected

Q1.PNG

When 'C' is selected

Q2.PNG

When nothing or both are selected

Q3.PNG