Need helpppppp

[anjanak]

I am a beginner in Qliksense I have data in this format

Value type             Value       Period

Actual                    50.5          1/8/21

Target                   80.10        1/8/21

Actual                  70.5         1/7/21

Target                73.5          1/7/21

Now I need to plot a bar chat With Period as X-axis And

Actual Value as Y-axis And a trend line of the target value 

Please help me with how to get this done

[stevejoyce]

Use Combo chart.

Dimension = Period

Expression1 = Sum({<Value type={'Actual'}>} Value) , display as bar

Expression2 = Sum({<Value type={'Target'}>} Value), display as line

[anjanak]

Hi Steve , thanks for the reply 

But I want to display the exact values not the aggregates like sum / count 

Every month has unique actual and target value 

I have to display just actual value without any aggregation for that particular month ..and a trend line displaying the target value for that month

Like wise for all months ..

[stevejoyce]

Did you use the calculations and see what happens?  I don't understand your concern.  You need some function around your field (max, sum, avg...).  If you only have 1 value and that's what you want to display then really your function doesn't matter.  If there is something else going on, please share details.

[anjanak]

Jan to Dec I have two set of Values one Is actual and other is Target 

I don't need any aggregate functions here 

I just need to plot for every month how much is actual (achieved) vs how much target we set for that particular month 

Like wise for every month data needs to be plotted 

The one you said is throwing an expression error

[stevejoyce]

Enclose your field names in [ ].  The set analysis is what limits to actual vs target.  If that's unclear I recommend you do some research on expressions and set analysis.  This is a straightforward calculation.

Sum({<[Value type]={'Actual'}>} [Value])

Sum({<[Value type]={'Target'}>} [Value])